URGENT Excel Automation Problems

tanderson54 · Apr 23rd, 2002, 11:53 AM

Dear Sir,

I have recently developed an application that uses late binding OLE to an Excel Application.
That entire part I am having no problem with. Although I may have inadvertantly messed up.
After testing the application one of my "associates" compiled and distributed the application from a
WinXP Pro O/S. Although at first glance the program and setup ran just fine. But when it came time to
create the Excel.Application, that too also worked, but as soon as any properties are set within the
Excel reference The program kicks out an "Automation Error (80010108)" After some research I finally
found the definition to this error code "Object Has Disconnected From Its Clients".

My Question is, which files where replaced on the Win98 Machine and how do I retrieve the correct versions
of these files, or maybe create a batch file to fix this "mess".

Any Help Would Be Appreciated
Thomas Anderson
Technical Coordinator
Cabinets 2000, Inc.
(562)868-0909
MSN: TAnderson54
AOLIM: Dante45Anderson

tanderson54 · Apr 23rd, 2002, 11:59 AM

Please, anyone?

Tom Schreiner · Apr 23rd, 2002, 12:13 PM

If you are using VB see:

See Microsoft Knowledge Base Article q295549

Tom

tanderson54 · Apr 23rd, 2002, 12:28 PM

That article would be real nice if i was using Win2k SERVER, but unfortunately that article had nothing to do with my Question!

I need the required Excel Automation files for Win98, Win98SE

Thanks

Tom Schreiner · Apr 23rd, 2002, 01:14 PM

Why can't the project be re-compiled on the Win98 machine?
I can send you the files you need.
If I am not understanding you, then you are over my head.
Tom

Tom Schreiner · Apr 23rd, 2002, 01:18 PM

Here is a dependency file from one of my projects which automates Excel:

[Version]
Version=1.0.0.0

[TradeTicker.exe <0009>]
Dest=$(AppPath)
Date=8/27/2001
Time=11:35
Version=1.0.0.0
CABFilename=TradeTicker.CAB
CABINFFile=TradeTicker.INF
Uses1=MSVBVM60.DLL
Uses2=OLEAUT32.DLL
Uses3=OLEPRO32.DLL
Uses4=ASYCFILT.DLL
Uses5=STDOLE2.TLB
Uses6=COMCAT.DLL
Uses7=EXCEL9.OLB

[EXCEL9.OLB <0009>]
Dest=$(WinSysPath)
Date=3/19/1999
Time=21:00
Version=9.0.0.2719

Is this what you need?
The Win98 version of these files?
Tom

Send me a dependency file from your project and I will send you the files...

[ This Message was edited by: TsTom on 2002-04-23 12:21 ]

tanderson54 · Apr 23rd, 2002, 01:30 PM

[Version]
Version=3.2.0.0

[PropPro.exe <0009>]
Dest=$(AppPath)
Date=4/23/2002
Time=12:24
Version=3.2.0.0
CABFilename=PropPro.CAB
CABINFFile=PropPro.INF
Uses1=msvbvm60.dll
Uses2=oleaut32.dll
Uses3=olepro32.dll
Uses4=asycfilt.dll
Uses5=stdole2.tlb
Uses6=COMCAT.DLL
Uses7=EXCEL9.OLB
Uses8=msado25.tlb
Uses9=COMDLG32.OCX
Uses10=mscomctl.ocx
Uses11=MSSTDFMT.DLL ;Not sure what this is doing? any help on what it does?

[msado25.tlb <0009>]
Dest=$(WinSysPath)
Date=8/18/2001
Time=05:00
Version=2.70.7713.0

Tom Schreiner · Apr 23rd, 2002, 01:32 PM

MSSTDFMT.DLL =
Microsoft Data Formatting Object Library

tanderson54 · Apr 23rd, 2002, 01:32 PM

oic

Tom Schreiner · Apr 23rd, 2002, 01:41 PM

mdac25?
32 bit
XP = 64 bit
No backward compatibility
Maybe that was the problem???
You may need to upgrade to 26 or 27 on all of your 98 machines

[ This Message was edited by: TsTom on 2002-04-23 12:42 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 11:53 AM	#1
tanderson54 New Member Join Date: Apr 2002 Location: Cabinets 2000, Inc. Posts: 14	Dear Sir, I have recently developed an application that uses late binding OLE to an Excel Application. That entire part I am having no problem with. Although I may have inadvertantly messed up. After testing the application one of my "associates" compiled and distributed the application from a WinXP Pro O/S. Although at first glance the program and setup ran just fine. But when it came time to create the Excel.Application, that too also worked, but as soon as any properties are set within the Excel reference The program kicks out an "Automation Error (80010108)" After some research I finally found the definition to this error code "Object Has Disconnected From Its Clients". My Question is, which files where replaced on the Win98 Machine and how do I retrieve the correct versions of these files, or maybe create a batch file to fix this "mess". Any Help Would Be Appreciated Thomas Anderson Technical Coordinator Cabinets 2000, Inc. (562)868-0909 MSN: TAnderson54 AOLIM: Dante45Anderson

Apr 23rd, 2002, 11:59 AM	#2
tanderson54 New Member Join Date: Apr 2002 Location: Cabinets 2000, Inc. Posts: 14	Please, anyone?

Apr 23rd, 2002, 12:13 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	If you are using VB see: See Microsoft Knowledge Base Article q295549 Tom

Apr 23rd, 2002, 12:28 PM	#4
tanderson54 New Member Join Date: Apr 2002 Location: Cabinets 2000, Inc. Posts: 14	That article would be real nice if i was using Win2k SERVER, but unfortunately that article had nothing to do with my Question! I need the required Excel Automation files for Win98, Win98SE Thanks

Apr 23rd, 2002, 01:14 PM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Why can't the project be re-compiled on the Win98 machine? I can send you the files you need. If I am not understanding you, then you are over my head. Tom

Apr 23rd, 2002, 01:18 PM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Here is a dependency file from one of my projects which automates Excel: [Version] Version=1.0.0.0 [TradeTicker.exe <0009>] Dest=$(AppPath) Date=8/27/2001 Time=11:35 Version=1.0.0.0 CABFilename=TradeTicker.CAB CABINFFile=TradeTicker.INF Uses1=MSVBVM60.DLL Uses2=OLEAUT32.DLL Uses3=OLEPRO32.DLL Uses4=ASYCFILT.DLL Uses5=STDOLE2.TLB Uses6=COMCAT.DLL Uses7=EXCEL9.OLB [EXCEL9.OLB <0009>] Dest=$(WinSysPath) Date=3/19/1999 Time=21:00 Version=9.0.0.2719 Is this what you need? The Win98 version of these files? Tom Send me a dependency file from your project and I will send you the files... [ This Message was edited by: TsTom on 2002-04-23 12:21 ]

Apr 23rd, 2002, 01:30 PM	#7
tanderson54 New Member Join Date: Apr 2002 Location: Cabinets 2000, Inc. Posts: 14	[Version] Version=3.2.0.0 [PropPro.exe <0009>] Dest=$(AppPath) Date=4/23/2002 Time=12:24 Version=3.2.0.0 CABFilename=PropPro.CAB CABINFFile=PropPro.INF Uses1=msvbvm60.dll Uses2=oleaut32.dll Uses3=olepro32.dll Uses4=asycfilt.dll Uses5=stdole2.tlb Uses6=COMCAT.DLL Uses7=EXCEL9.OLB Uses8=msado25.tlb Uses9=COMDLG32.OCX Uses10=mscomctl.ocx Uses11=MSSTDFMT.DLL ;Not sure what this is doing? any help on what it does? [msado25.tlb <0009>] Dest=$(WinSysPath) Date=8/18/2001 Time=05:00 Version=2.70.7713.0

Apr 23rd, 2002, 01:32 PM	#8
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	MSSTDFMT.DLL = Microsoft Data Formatting Object Library

Apr 23rd, 2002, 01:41 PM	#10
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	mdac25? 32 bit XP = 64 bit No backward compatibility Maybe that was the problem??? You may need to upgrade to 26 or 27 on all of your 98 machines [ This Message was edited by: TsTom on 2002-04-23 12:42 ]