URGENT Excel Automation Problems

[tanderson54]

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]

Please, anyone?

 

[Legacy 98055]

If you are using VB see:

See Microsoft Knowledge Base Article q295549

Tom

 

[tanderson54]

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

 

[Legacy 98055]

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

 

[Legacy 98055]

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]

[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

 

[Legacy 98055]

MSSTDFMT.DLL =
Microsoft Data Formatting Object Library

 

[tanderson54]

oic

 

[Legacy 98055]

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