title: VBA changing active workbook
body: <p>I have a spreadsheet where in the VBA it goes off opening other spreadsheets and temporarily setting these to the active <code>worksheet</code>.</p>
  
  <p>However, I have a loop and at the end of the first iteration I need to set the active worksheet to be the original one which started the VBA module. I cannot set a new <code>Workbook</code> object to open the original, because the original is still open in the background and it says its already open.</p>
  
  <p>My problem is that I need to change the active <code>Workbook</code> to the original one, when I never had a workbook object to refer to it???</p>
  
  <pre><code>'Original workbook is active implicitly
  
  'loop begins
  
  'change active workbook to something else
  
  
  'Need to change back to original workbook here- but don't have a VBA workbook object
  
  'end of loop
  </code></pre>