Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
I have a workbook with macros that was developed using Excel 2000. It has
been working fine. Recently, I have Excel 2003 installed in addition to Excel 2000. So there are two versions of Excel on my computer. Now when I open this workbook. I received an error message: Runtime error -2147417848 (80010108) Automation Error: The object invoked has disconnected from its client. And Excel freezes. Is having two versions of Excel causes this problem? Can someone please help me resolve this? Thanks! JH |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
I run three versions of Excel on my machine without problems.
(though, I don't have xl 2003) Each version should be installed in a separate folder and only one version should be open at any time. Also, do you have code in the workbook.open event? If so, that could be contributing to the problem. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "JH" wrote in message I have a workbook with macros that was developed using Excel 2000. It has been working fine. Recently, I have Excel 2003 installed in addition to Excel 2000. So there are two versions of Excel on my computer. Now when I open this workbook. I received an error message: Runtime error -2147417848 (80010108) Automation Error: The object invoked has disconnected from its client. And Excel freezes. Is having two versions of Excel causes this problem? Can someone please help me resolve this? Thanks! JH |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
There is a work book open() event in Thisworkbook.
But what I noticed is when I open this file using Excel 2003, the problem does not replicate. I can not explain what happened. I am now suspecting somehow the necessary dll "went" over to the newer version. So using the newer version resolve the problem. JH "Jim Cone" wrote: I run three versions of Excel on my machine without problems. (though, I don't have xl 2003) Each version should be installed in a separate folder and only one version should be open at any time. Also, do you have code in the workbook.open event? If so, that could be contributing to the problem. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "JH" wrote in message I have a workbook with macros that was developed using Excel 2000. It has been working fine. Recently, I have Excel 2003 installed in addition to Excel 2000. So there are two versions of Excel on my computer. Now when I open this workbook. I received an error message: Runtime error -2147417848 (80010108) Automation Error: The object invoked has disconnected from its client. And Excel freezes. Is having two versions of Excel causes this problem? Can someone please help me resolve this? Thanks! JH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-Time Error'-2147221080(800401a8)': Automation Error | Excel Programming | |||
Compile error automation error | Excel Programming | |||
RunTime Error (Automation Error) | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |