What causes MS VB Run-time Error -2147417848 (80010108) in Excel Macro

Question

I have a macro which runs fine on my machine but when I try to run it on another machine it gives the following error.

Microsoft Visual Basic

Run-time Error -2147417848 (80010108)
Automation Error
The Object invoked has disconnected from its clients.

Answer 1

Here is a possible solution. I haven't encountered the error myself so I'm not sure so...

Also, more detail would be helpful, what is the code surround the line where it errors? What is the code doing? Are both machines running the same version of Windows and Excel?

Answer 2

Thankyou for your reply jeffrymb but i have solved the issue while back.

regards