View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JonOfAllTrades JonOfAllTrades is offline
external usenet poster
 
Posts: 6
Default How to instantiate Excel 2003 when both 2003 and 2007 are installe

"Raghu" wrote:

I have both Excel 2003 (ver 11) and Excel 2007 (ver 12) installed on my
machine and I'm trying to instantiate Excel 11 app by doing

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

Despite the version specific progID, ver 12 application is instantiated.
Would anyone have suggeestions on instantiating an Excel 2003 instance
programmatically?

Any help is greatly appreciated.


I've had that problem too, very maddening. My C# app specifically
references the 11 libs, because that's what everyone has, but at run time it
somehow decides it must have 12. The worst thing about it is that I somehow
got it to recognize the right libraries, months ago, but I had to reinstall
Office when it got damaged and now it's broken again.