title: working with different workbooks within the same code
body: <p>When referring to different workbooks within a code I have been using "Set Workbooks.Open". </p>
  
  <p>Example:</p>
  
  <pre><code>`Dim wbname1 as Workbook
  Dim wbname2 as Workbook
  
  
  'code which refers to wbname1
  Set wbname1 = Workbooks.Open("path\filename")
  
  'code which refers to wbname2
  Set wbname2 = Workbooks.Open("path\filename")`
  </code></pre>
  
  <p>This is sometimes inconvenient because in order to refer again to a previous workbook, I would have to close the workbook and reopen it.</p>
  
  <p>Example:</p>
  
  <pre><code>` 'code which refers to wbname1
  Set wbname1 = Workbooks.Open("path\filename")
  wbname1.Close True
  
  'code which refers to wbname2
  Set wbname2 = Workbooks.Open("path\filename")
  
  'code which refers again to wbname1
  Set wbname1 = Workbooks.Open("path\filename")`
  </code></pre>
  
  <p>I have had to work around this problem especially when using different workbooks within a loop.</p>
  
  <p>Is there an easier way to refer to different workbooks than using</p>
  
  <p><code>Set Workbooks.Open()</code></p>