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.
Automate version of Excel
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Automate version of Excel
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Automate version of Excel
What happens if you use CreateObject("Excel.Application.11") ?
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Automate version of Excel
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.
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.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Automate version of Excel
Good luck! If you can't find it, you might post some or all of the code you're using.
Best wishes,
Hans
Hans