the number on the end makes no difference - the last registered version is
started.

There is a KB article on this.

--
Regards,
Tom Ogilvy


"Juan Pablo González" wrote in message
...
Weird, I don't have a machine with both of them installed, but on the
machine with 2007, that line creates a run time error, only when I change
it to Excel.Application.12 it works.

So, try what Jim Rech said and see if that helps.

Regards,

Juan Pablo González

"Dave" wrote in message
...
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