title: How to store a Workbook name as a variable?
body: <p>I have WorkbookA.xlsm and my code directly references "WorkbookA.xlsm"</p>
  
  <p>When my workbook is distributed, not everybody leaves the name the same and it causes 'subscript out of range' errors.</p>
  
  <p>How can I declare a workbook as a variable or similar? <code>thisworkbook.name</code>?</p>
  
  <p>My product opens a separate workbook, pulls data from it, and then places it into my workbook - I was worried <code>thisworkbook</code> or similar might cause issues if more than one are open.</p>