ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automation Error (https://www.excelbanter.com/excel-programming/374992-automation-error.html)

JH

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




Jim Cone

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




JH

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






All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com