View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default Choosing the Version of Excel when opening an instance

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