Automate version of Excel

[agibsonsw]

Hello again. Office 2003.
I'm automating Excel from Access but the computer has both 2000 and 2003 versions.
I'm using CreateObject("Excel.Application"). Is it possible to specify the version of Excel to start? As it currently attempts
to start 2000 and I receive a server error message.
I tried changing the windows default for opening .xls files but this didn't seem to work.
Thanks, Andy.

[HansV]

What happens if you use CreateObject("Excel.Application.11") ?

[agibsonsw]

Hello.
I guessed that myself! but it didn't resolve the problem.
The sequence actually fails as it attempts to open a workbook, so I'll continue to investigate if there is a problem with the file, name or path.
Thanks, Andy.

[HansV]

Good luck! If you can't find it, you might post some or all of the code you're using.