CreateObject("Excel.Application") two version of Excel installed

[hobgoblinvasya]

Hi

its me again I have two versions of Excel installed on my pc (2003 and 2007). How can i programmatically create separate objects for each version? is it even possible?

CreateObject("Excel.Application") returns the most recently installed/repaired version. however i need to check both of them.

any help will be highly appreciated.

cheers !

 

[Legacy 98055]

Just include the version number though I cannot assure you that you will be without problems...

CreateObject("Excel.Application.11")
CreateObject("Excel.Application.12")

Have a nice day

 

[hobgoblinvasya]

hi Tom,

thanks for the reply. I have tried doing that already. what happens is since 2003 and 2007 share the same clsid, only the latest excel version gets loaded. so if you have 2007 as the most recently installed and you try - CreateObject("Excel.Application.11") - and then see the version of the object, it will be version 12, not 11

any other ideas?

 

[Legacy 98055]

I don't know then. Without a unique prog id, I don't know of any way to do this.