View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave[_76_] Dave[_76_] is offline
external usenet poster
 
Posts: 5
Default Choosing the Version of Excel when opening an instance

That still opens up the 07 version...
"Juan Pablo González" wrote in message
...
Try using

Set xlApp = CreateObject("Excel.Application.11")

Regards,

Juan Pablo González

"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