Hi,

I've got the automation error -2147417848 (80010108). The objec
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 i
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 comment
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 carryin
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, bu
working version of a file. This Excel corruption hapepned to me alread
a few times and it's really annoying because I had to rewrite lots o
code again. Moreover after such a event I do not trust the code as i
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 & Norto
Internet Security + some antitrojan software.

Thanks,


Mik

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

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/

Thanks for help!

Finally it seems to me the reason was is the corrupted *.xls repor
file.

After copying the contents of all pages and modules into a new workboo
I realized there is also a bit corrupted chart (I could edit it, bu
after saving and opening it came back to the original not edite
shape).

After making this chart again from scratches now it seems to be OK.

Thanks again.


Micha

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