+ Reply to Thread
Results 1 to 3 of 3

Automation error object invoked has disconnected

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    49

    Automation error object invoked has disconnected

    Good Day Folks,

    I have a very very annoying problem that is intermittent, in other words, my full code works 5 to 10 times, then it crashes with a automation error as above title. The circumstances are all the same every time, always crashing 70% into my progress bar, so I know something is wrong between 70% and 80%. Just a note: The VBA is run as a macro off another macro through a CALL. And in this code it is supposed to save and close the ARCHIVE.xlsb file (All it needs to do!). There is also multiple users using the archive file, but only 1 by 1 as I have another code handling the read-only status of the file, and as the error only happens when closing the file, I see no reason how multiple users can cause it to crash. And it works 99% percent of the time, only seldom crashes with an automation error.

    My code (where it crashes)

    Please Login or Register  to view this content.
    My other untried alternative is putting in a On Error Resume - So it loops until it gets it right. But before I do that, I am asking the experts.

    Thank You

    JEDEMEYER1

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Automation error object invoked has disconnected

    Where does the code error?

  3. #3
    Registered User
    Join Date
    03-01-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Automation error object invoked has disconnected

    Dave,

    Between 70 & 80.

    When activating the sheet. Remember - It only happens randomly - Not always.

    Strange problem

    Kind Regards,

    JEDEMEYER1

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automation error , the object invoked has disconnected from its clients
    By lini1985 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2014, 08:55 AM
  2. [SOLVED] Automation error Object invoked has disconnected from its clients
    By BobMillar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2014, 06:59 AM
  3. 2147417848 automation error the object invoked has disconnected from its clients
    By KasiaFavourite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2011, 10:44 AM
  4. -2147417848 automation error the object invoked has disconnected from its clients
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-12-2011, 08:10 AM
  5. Automation Error : The Object Invoked Has Disconnected From Its Clients !!
    By donna.gough@hydro.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1