title: reference different workbooks worksheets using object variables The workbook is already open
body: <p>I'm pounding my head against the wall with this. I've been writing the full workbooks().sheets() references. Looking for a shorter way to do it I found some stackoverflow posts and answers that seem so simple but when I try it... it doesn't work.
  I don't need to open the workbook I want to reference since I found a way to code it to open automatically when the main workbook opens... and save and close when the main closes. 
  I get a "Compile error: sub or function not defined" at the Set wb = Workbooks() line.</p>
  
  <p>I followed as closely the answer to this question <a href="https://stackoverflow.com/questions/13146558/referencing-workbook-and-worksheet-by-variables">Referencing Workbook and Worksheet by Variables</a></p>
  
  <p>Is there a special place to define an object variable or may it be done in any sub or function when needed. Also Is there a place I can define it where the whole project sees it so I only have to define it once. If so I'll define them all in that location and always use the shorthand references.</p>
  
  <pre><code>Public Sub VTest()
  
  Dim WbStats As Workbook
  Dim WSPO1sts As Worksheet
  
  Set WbStats = Worksbooks("Stats.xlsx") 'this line spawns the compile error I mentioned.
  Set WSPO1sts = WbStats.Sheets("PO1sts")
  </code></pre>