Choosing the Version of Excel when opening an instance
Hmmm...in my references it only shows the office 12 objects, not excel 11.
I did re-register and it still does not show up....
"Jim Rech" wrote in message
...
You might try re-registering Excel 2003. From Start-Run enter:
<Full path to Excel 2003\Excel.exe /regserver
--
Jim
"Dave" wrote in message
...
| I'm using vba with ms project and excel, pulling the tasks from project
to
| excel. I have excel 2007 and 2003 installed on my computer. By default
| when I use
| Set xlApp = New Excel.Application
| xlApp.Visible = True
| AppActivate "Microsoft Excel"
|
| The 2007 version is used. I would like to use the 2003 version. Any
help
| is appreciated.
|
| Cheers
|
|
|