title: VB Script - Calling Excel 2007 explicitly when both Excel 2003 and Excel 2007 are installed
body: <p>My PC has both Excel 2003 and 2007 as well as the Excel 2007 compatibility pack installed, it also has a VB script that build records into an csv file automatically. Recently, the number of records that are needed to dump into the file has grown significantly and went beyond the row limit in Excel 2003. As such, I made a copy of the same file and saved it into .xlsm format.
  However, when I use the VBScript to run the macro behind the Excel spreadsheet by calling:</p>
  
  <pre><code>Set myApp = CreateObject("Excel.Application")
  </code></pre>
  
  <p>The Excel file still attempted to open itself to convert (using the compatibility pack) to Excel 2003 and run in Excel 2003, which inevitably gives an error every time it runs.</p>
  
  <p>Is there any way I could force Excel.Application to point to Excel 2007 instead of Excel 2003?</p>
  
  <p>Thanks!</p>