Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to instantiate Excel 2003 when both 2003 and 2007 are installe
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to instantiate Excel 2003 when both 2003 and 2007 are inst
"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. OK, this is what I got to work: delete your existing Excel reference, and add this (or equivalent on your machine): C:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.E xcel\11.0.0.0__71e9bce111e9429c\Microsoft.Office.I nterop.Excel.dll By referencing the 11.0 this way, it seems to stick to that version and not switch to 12.0. Apparently it decided to change the 11 reference to 12 all on its own when I reinstalled my software, but I've forced it back again. This is a partial fix: on my computer, it STILL runs 12.0, but on other machines with 11 installed but NOT 12, it runs the correct version. To put it another way, it still uses the latest version, if available, but no longer requires it. Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Excel opens two windows (2007 & 2003 format): I want only 2003. | Excel Discussion (Misc queries) | |||
Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta | Excel Discussion (Misc queries) | |||
Saving from 2007 to 2003 - 2003 won't open the file | Excel Discussion (Misc queries) | |||
VBA Access lost after 2007 file format compatibility pack installe | Excel Discussion (Misc queries) |