>I've got a situation where I need to use 2003 to create some files and 2007 to create others.
>
>2003 was installed first a long time ago and 2007 installed today. So 2007 took over everything file associations/registery etc...
>
>I needed to run the 2003 version process and since both versions have the same CLSID I did run "...office10\excel.exe /regserver" and sure enough 2003 became the version of choice everywhere...
>
>Now I have to create the 2007 version process... run "..office12\excel.exe /regserver", Excel starts and runs for 30 seconds and closes like it's supposed to, but does not cause 2007 to be the version created by createobject( "excel.application" ) or double clicking an xls file in explorer.
>
>Has anyone figured out a way to swap back and forth? I'm not in an environment where I can keep the 2007 install disk.


Can you just use CREATEOBJECT("Excel.Application.11") and CREATEOBJECT("Excel.Application.12")? The double clicking part would still be a problem.

(Howdy, Dave. Long time no see.)