Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: URGENT Excel Automation Problems

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Cabinets 2000, Inc.
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    New Member
    Join Date
    Apr 2002
    Location
    Cabinets 2000, Inc.
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please, anyone?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you are using VB see:

    See Microsoft Knowledge Base Article q295549

    Tom

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Cabinets 2000, Inc.
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  7. #7
    New Member
    Join Date
    Apr 2002
    Location
    Cabinets 2000, Inc.
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [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


  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    MSSTDFMT.DLL =
    Microsoft Data Formatting Object Library

  9. #9
    New Member
    Join Date
    Apr 2002
    Location
    Cabinets 2000, Inc.
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    oic

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •