stanl
10-21-2011, 06:43 AM
I combined Excel 2007 and 2003 on a single XP machine. I have no problem opening either app from the start menu and can use the SaveAS fileformat:= to save as either a 2003 or 2007 file. I also know the CLSID is the same so a CreateObject("Excel.Application") will default to the higher version.
Still, I read that by manipulating a couple of registry keys, you could issue either
CreateObject("Excel.Application.11") ;2003
CreateObject("Excel.Application.12") ;2007
but after doing this, Excel still opens as 2007. This is a relative non-issue as all code to automate workbooks still works, but I was hoping I could run some legacy stuff and have Excel 2003 open.
This is probably a lost cause, but I thought I'd ask in case someone has figured it out.
TIA
Still, I read that by manipulating a couple of registry keys, you could issue either
CreateObject("Excel.Application.11") ;2003
CreateObject("Excel.Application.12") ;2007
but after doing this, Excel still opens as 2007. This is a relative non-issue as all code to automate workbooks still works, but I was hoping I could run some legacy stuff and have Excel 2003 open.
This is probably a lost cause, but I thought I'd ask in case someone has figured it out.
TIA