Excel and HMG (or another application)

[mol]

Hi guys!

I have computer with 2 version of ms office istalled (2003 and 2007).
If i use:

Code: Select all

oExcel := CreateObject( "Excel.Application")

I will open Excel 2007.
How to force opening Excel 2003?

Has anybody got any idea how to do it?

[mol]

I found solution!!!
I wanna put it to help somebody, which will try to work with multiple office versions on one computer.

You can read about it on MS pages:
http://support.microsoft.com/kb/292491
As you can read on these pages, always latest installed application is called via OLE.

But, simply, you can call

Microsoft excel 2002 (XP)

Code: Select all

oExcel := CreateObject( "Excel.Application.10")

Microsoft excel 2003

Code: Select all

oExcel := CreateObject( "Excel.Application.11")

Microsoft excel 2007

Code: Select all

oExcel := CreateObject( "Excel.Application.12")

I will test it today on my second computer at home.
If something will be bad, I will write about it.

Best regards, Marek

[swapan]

Thanks Mol!

[luisvasquezcl]

Thanks Mol.
Regards,

[Vanguarda]

Hi all,

Thanks Mol, great post.



regards,

[salamandra]

Hi Mol,

I found solution!!!
I wanna put it to help somebody, which will try to work with multiple office versions on one computer.

You can read about it on MS pages:
http://support.microsoft.com/kb/292491
As you can reead on these pages, always latest installed application is running.


But, simply, you can call

Microsoft excel 2002 (XP)

Code: Select all

oExcel := CreateObject( "Excel.Application.10")

Microsoft excel 2003

Code: Select all

oExcel := CreateObject( "Excel.Application.11")

Microsoft excel 2007

Code: Select all

oExcel := CreateObject( "Excel.Application.12")

I will test it today on my second computer at home.
If something will be bad, I will write about it.

Best regards, Marek

This will be very, very, very useful for me

Regards,

Salamandra

[mol]

I've tested my argument with Excel 2002 (XP) and Excel 2007.
It works as I expected!

[Rathinagiri]

Oh! Nice.