Results 1 to 4 of 4
  1. #1
    glensmith
    Guest

    Excel Automation Gone To Pot (VB6)

    Ok, so I could insert a spreadsheet on my form as an OLE Object yesterday. But I try today and get
    Systen Error &H80080005 (-21469593555). Server Excecution Failed.
    Now I don't speak that Type of language, so I am struggling a bit.
    I have done the usual - repaired office, removed office, re-installed office, but is still comes up with the same error.

    I am using W2K SR2 with Office 2K SP1 and VB6.

    Any help may just prevent a computer from meeting an early bath.

    Glen Smith
    (Sorry - not created a fancy signature yet)

  2. #2
    glensmith
    Guest

    Re: Excel Automation Gone To Pot (VB6)

    Update

    I have just found out that if I load Excel before inserting it, it inserts fine. Without Excel Loaded it shows the message.

    Not sure if that helps

    Glen

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Automation Gone To Pot (VB6)

    I'm not sure I can help, but I can sympathize. I have strange occasional problems with automating Word 2K SP1 from VB6 SP5. Sometimes the "method ~ of object ~ failed" error appears. I can usually cure it by rebooting the NT4 SP6A box or launching Word and then closing Word. Anything is the MS KB about your error? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Automation Gone To Pot (VB6)

    Since this is the VBA forum, I assume you are inserting the xls using code. Post the code so we can see.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

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