CreateObject(.Excel.Application.) target 2003 when 2007 2010 or later installed


Text workstation has both 2003 & 2010 office installed

Access 2003 VBA:

Set xlsApp = CreateObject("Excel.Application")

is opening Excel 2007 but for testing I need it to run 2003

Solution per:

This will set excel 2003 as the default but if you try to open an xlsx it will use 2007.

Run > "C:\your path to\office11\excel.exe" /regserver



"C:\Program Files\Microsoft Office\OFFICE11\excel.exe" / regserver

Nope didn't work