title: How to get reference to an open Excel spreadsheet from Word?
body: <p>I have some VBA code that copies stuff from Excel and pastes it into Word. The problem I'm having is how to open the spreadsheet. I can open it using an absolute path reference by</p>
  
  <blockquote>
    <p>Workbooks.Open "C:\path\filename.xls"</p>
  </blockquote>
  
  <p>I would prefer to reference the spreadsheet using a relative path reference. I was able to find code for relative path references from an Excel workbook to another one but it doesn't seem to work if you're doing it from Word.</p>