Cindy
Fri Feb 11 15:18:45 CST 2005
Hi Scott,
I Googled this problem
(
http://groups-beta.google.com/groups?q=Excel+%22The+object+invoked+has+disconnected+from+its+clients%22&qt_s=Search+Groups)
and there's not a lot of information. Here's some of what I found:
>>Lori Turner [MS] Apr 15 2002, 2:27 pm show options
Newsgroups: microsoft.public.excel.programming
From: Lor...@online.microsoft.com (Lori Turner [MS]) - Find messages
by this author
Date: Mon, 15 Apr 2002 21:15:51 GMT
Local: Mon, Apr 15 2002 2:15 pm
Subject: RE: the object invoked has disconnected from its clients
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse
Hi Bob,
The error "The object invoked has disconnected from its clients" is often a
side effect of an unqualified reference. If you are using early binding
for automation to Excel, check that all your method/properties calls to
Excel are qualified. See this article for more details:
Excel Automation Fails Second Time Code Runs (Q178510)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q178510
For more information, sample code or other resources for using Office with
Visual Basic, Visual C++, Internet Scripts, and other programming
languages, visit:
Microsoft Office Development with Visual Studio
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/VS...
ev.htm
Regards,
Lori Turner
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.
<<
>> Don Aug 19 2003, 10:15 am show options
Newsgroups: microsoft.public.excel.crashesgpfs
From: "Don" <d...@mips.ne.jp> - Find messages by this author
Date: Tue, 19 Aug 2003 10:13:27 -0700
Local: Tues, Aug 19 2003 10:13 am
Subject: The object invoked has disconnected from its clients
Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
I have found that the presence of any Picture in the
workbook, with any Macro Assigned to the picture causes
this problem without fail.
I delete the Mactro Assigned Picture, leaving many other
pictures, and the third copy works fine.
<<
>>
Bob Umlas Mar 12 2003, 11:08 am show options
Newsgroups: microsoft.public.excel.programming
From: "Bob Umlas" <rum...@kpmg.com> - Find messages by this
author
Date: Wed, 12 Mar 2003 14:04:28 -0500
Local: Wed, Mar 12 2003 11:04 am
Subject: Re: Error Message: "The object invoked has disconnected
from its clients"
Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
If you DO have userforms, I'd suggest exporting them, removing them
from the
workbook, save & close the workbook, reopen the workbook, re-import
the
userform, save the workbook.
Perhaps the UF has gotten corrupted -- this technique worked for me,
suggested by fellow MVPs when I had the same problem.
Bob Umlas
Excel MVP
<<
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
"Scott Cadreau" <scadreau@aros.net> wrote in message
news:QOadnfVvFKoTSZbfRVn-1Q@aros.net...
>I am getting a strange Excel error in my application.
>
> <snip>
> tmpsheet=getobject('', 'excel.sheet')
> XLApp=tmpsheet.Application
> XLApp.Visible=.f.
> <snip>
>
> I am getting an error on the "XLApp=tmpsheet.Application" line.
> OLE error code 0x80010108: The object invoked has disconnected from its
> clients
>
> Can anyone tell me how to fix this?
>
> Thanks,
>
> Scott
>
>
begin 666 dot_clear.gif
K1TE&.#EA`0`!`( ``/___P```"'Y! $`````+ `````!``$```("1 $`.P``
`
end