Object creating Excel 95 rather than Excel XP

[TimGoff]

Hi,

I have Excel 95 and XP on my desktop. When I create a Excel object in my code using...

Set objExcel = CreateObject("Excel.Application&quot

...is fires up 95 rather than XP.

How do I change it to XP?

Thanks in advance,

Tim

 

[RobBroekhuis]

I'm still on 2000, so my VBA help doesn't go far enough - but you should be able to do something like:

Set objExcel = CreateObject("Excel.Application.9&quot

(I think that particular one starts up Excel 2000).

Check your VBA help, topic "OLE Programmatic Identifiers"
Rob

 

[TimGoff]

Works a treat - thanks Rob

For reference Excel XP is Excel.Application.10 - which makes sense really