+ Reply to Thread
Results 1 to 2 of 2

Automation error disconnected (80010108), sporadic

Hybrid View

  1. #1
    Registered User
    Join Date
    03-24-2015
    Location
    Quebec
    MS-Off Ver
    2007,2010
    Posts
    1

    Automation error disconnected (80010108), sporadic

    I have been working on an excel vba project (for a purchasing department, issuing all sorts of tasks automatically, saved in xlsm format). The project is developing well and I was in my last phase of a beta. One day, I came back from vacation (2nd week of march, may be important) and I was getting a 80010108 error (Automation error, object was disconnected...) I was able to confirm that no change had been done to the spreadsheet. By playing with the spreadsheet further, I found the following:

    1) The problem will disappear if I open the VBA editor and save/close the file.
    2) After the problem disappeared, reopening the file will allow the vba to run fine, until it is saved/closed again.
    3) The problem will persist until the VBA editor is opened again
    4) The problem happened all at once on all of my windows XP machines
    5) My windows 8 machines seem to be unaffected by the bug. But if the file is in a "broken" state, they will still issue the error message.
    6) Going to every previous backup of the xlsm results in the same issue, although the problem did not happen before my vacations
    7) No viruses/spywares/rootkits or other were found in any of the computers
    8) Putting alerts in every step of the program, and commenting out offending lines when found, allowed me to find that the bug is created by changing (in vba) the captions and values of specific labels and textboxes. It is always the same offending elements, although in the programming, they are part of numerous similar changes
    9) Deleting/Copying/Renaming any of the offending lines/elements do not seem to affect the problem... It always occurs on the same elements, independently of its name/position in the programming
    10) Saving the xlsm in the older format (xls) prevents the issue from happening again (although I need the extra excel rows and columns). Saving it again in xlsm recreates the same issue.
    11) Qualified/Unqualified calls do not seem to change anything (as was suggested by various sites)
    12) Reinstalling/Registering/Deleting Registry key for MSComctl.ocx did not change anything (as was suggested by various sites)

    I could send the spreadsheet, but I honestly doubt it would be of use since the problem seems related to something else. And the problem occurs on something as simple as : label1.caption="Label Caption"

    The problem is literally driving me nuts and seemed to have happened similarly to some other people before... But so far, nothing seemed to have worked for me... Any suggestions?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,228

    Re: Automation error disconnected (80010108), sporadic

    Hi begee and welcome to the forum,

    I first thought daylight saving time might have got you but if you can still get the problem that isn't it.

    VBA macros simply send stuff to the machine and if you are doing other stuff, like opening files or the such, the macro sends it to the wrong program. I suggest you try using some DoEvents in your code to let the OS do what it needs to do and keeps the macro running on your Excel program instead of others.

    http://vbcoderesources.blogspot.com/...ts-in-vba.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. [SOLVED] Runtime Error -2147417848 (80010108) The Object Invoked Has Disconnected
    By johndoe86x in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2013, 08:24 AM
  2. Replies: 0
    Last Post: 10-25-2013, 03:58 PM
  3. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  4. Run-Time Error '-21474417848 (80010108)': Automation Error
    By robotzel78 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2012, 12:55 PM
  5. Replies: 12
    Last Post: 04-15-2010, 08:20 PM

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