title: Calling a function from another Excel workbook
body: <p>I've got a pile of data in one worksheet that I am trying to save to individual workbooks based on values in several columns. The approach I am taking (for better or worse!) is to copy the relevant worksheet (and macros) to a new workbook, save it with an appropriate name (let's say <code>temp.xlsx</code>), and then to cleanse the data in that new workbook by deleting irrelevant rows (function called <code>deleteInfo</code>). This all has to be done without altering the original workbook, as per company policy.</p>
  
  <p>I can copy the stuff over no problem, but I'm having serious issues calling macros in the new workbook then.</p>
  
  <p>I have tried:</p>
  
  <pre><code>Application.Run "'temp.xlsx'!deleteInfo"
  
  ActiveWorkbook.Application.Run deleteInfo
  
  Application.Run ("'C:\user\.....\temp.xlsx'!deleteInfo")
  </code></pre>
  
  <p>But none have worked.</p>