i have a vb6 program that reads an access database, a word document, 2
text files, writes a new word document, an excel spreadsheet and updates
1 of the text files. a lot of code so i cant post it here.
it works great from the IDE but when i do a make and then run as an
application (even after installing it with the package and deployment
wizard) i get teh following message
run time error '-2147417848(80010108)':
Automation error
the object invoked has disconnected from its clients
and then it cancels so i have no idea what is wrong.
help! Please!
thanks in advance for any assistance.
Woody
I am not responsible for anything you may see with my name attached to
it, i think.
Ashok Gupta (sujashi) - 30 Jul 2003 12:07 GMT
Check these links:
http://dbforums.com/arch/211/2003/4/487581
and a reply from MS Tech people
-------------------------------------------------
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/VSOfficeD
ev.htm
Regards,
Lori Turner

Signature
Ashok Gupta - ashi
This posting is provided "AS IS" with no warranties, and confers no rights.
> i have a vb6 program that reads an access database, a word document, 2
> text files, writes a new word document, an excel spreadsheet and updates
[quoted text clipped - 20 lines]
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
Ashok Gupta (sujashi) - 30 Jul 2003 12:08 GMT
Chek this known bug too'
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q293631

Signature
Ashok Gupta - ashi
This posting is provided "AS IS" with no warranties, and confers no rights.
> i have a vb6 program that reads an access database, a word document, 2
> text files, writes a new word document, an excel spreadsheet and updates
[quoted text clipped - 20 lines]
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!