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

Try using

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

Regards,

Juan Pablo González

"Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

That still opens up the 07 version...
"Juan Pablo González" <(E-Mail Removed)> wrote in message
news:%23uRl$(E-Mail Removed)...
> Try using
>
> Set xlApp = CreateObject("Excel.Application.11")
>
> Regards,
>
> Juan Pablo González
>
> "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>
>

You might try re-registering Excel 2003. From Start->Run enter:

<Full path to Excel 2003>\Excel.exe /regserver

--
Jim
"Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| 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
|
|

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> That still opens up the 07 version...
> "Juan Pablo González" <(E-Mail Removed)> wrote in message
> news:%23uRl$(E-Mail Removed)...
>> Try using
>>
>> Set xlApp = CreateObject("Excel.Application.11")
>>
>> Regards,
>>
>> Juan Pablo González
>>
>> "Dave" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You might try re-registering Excel 2003. From Start->Run enter:
>
> <Full path to Excel 2003>\Excel.exe /regserver
>
> --
> Jim
> "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> | 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
> |
> |
>
>

Ok, this is what I had to do for it to work.

From Project, I had to disable the current reference I had to Office 12,
browse to the
C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.dll to add this
reference. Go back and add the Excel 12 reference, make sure that the
office 11 is before the excel 12 and it now works...

Thanks

"Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> That still opens up the 07 version...
>> "Juan Pablo González" <(E-Mail Removed)> wrote in message
>> news:%23uRl$(E-Mail Removed)...
>>> Try using
>>>
>>> Set xlApp = CreateObject("Excel.Application.11")
>>>
>>> Regards,
>>>
>>> Juan Pablo González
>>>
>>> "Dave" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> 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
>>>>
>>>
>>>
>>
>>
>
>