It would appear that either a COM object has gone AWOL. I think this error
occurs when a COM object is invoked and then closed while a client is still
active. The client tries to reference the old object reference and is unable
to, hence the error.

It is also posisble that a shared dll has been deregistered or replaced by
an incorrect version. Have you installed any other software around the time
that the problem first appeared that may have installed dll's to
x:\Windows\System32?

Just a couple of things to check - others with more experience may have a
better idea.

Cheers,
Rodney


"mbobro " wrote in message
...
Hi,

I've got the automation error -2147417848 (80010108). The object
invoked has disconnected from its clients.

It happen while trying to save.as workbook.

The problem is I've used the absolutely same code several times and it
worked well. Then suddenly it appeared and I can't avoid it.

I've tested and I'm sure this is when I save, as when I made comments
on this save.as line it goes smoothly.

I've tried to repair and then reinstalled Office XP with no results.
I've exported all the modules from Excel Workbook I use for carrying
this macro and imported into a blank new one with no effects as well.

Please help me what should I do apart from using my previous, but
working version of a file. This Excel corruption hapepned to me already
a few times and it's really annoying because I had to rewrite lots of
code again. Moreover after such a event I do not trust the code as it
may be corrupted also somewhere else where I can't see it now :(

My configurations:

AMD Thunderbird 1.4 MHz
Win XP
Office XP (used to be SP-2 with all updates, now just blank Office XP)

Virus infection always possible, but I use Norton Antivirus & Norton
Internet Security + some antitrojan software.

Thanks,


Mike


---
Message posted from http://www.ExcelForum.com/