HMGforum.com

Hi guys!

I have computer with 2 version of ms office istalled (2003 and 2007).
If i use: I will open Excel 2007.
How to force opening Excel 2003?

Has anybody got any idea how to do it?

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) Microsoft excel 2003 Microsoft excel 2007 I will test it today on my second computer at home.
If something will be bad, I will write about it.

Best regards, Marek

Thanks Mol!

Thanks Mol.
Regards,

Hi all,

Thanks Mol, great post.



regards,

Hi Mol,

mol wrote: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

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

Oh! Nice.