A personal repository of random information in compensation for a fatigued biological computer
Breaded IT » MS Access / SQL Server reminders » CreateObject(.Excel.Application.) target 2003 when 2007 2010 or later installed
Scenario:
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: http://forums.networkautomation.com/forum/messageview.cfm?catid=4&threadid=7629
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
xxx
"C:\Program Files\Microsoft Office\OFFICE11\excel.exe" / regserver
Nope didn't work