+ Reply to Thread
Results 1 to 5 of 5

runtime Automation Error -2147417848

  1. #1
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2016 (Office 365)
    Posts
    137

    runtime Automation Error -2147417848

    Hi there,

    I call this sub from a much larger sub to copy and name a particular worksheet. The sub works fine 9 times out of 10 but on the odd occasion I get a Automation Error with the note "The object invoked has disconnected from its client". I have done a lot of reading about this error but cannot find a solution. One solution was to edit the worksheet first to activate is hence the .clearcontents lines of code however these do not appear to be helping.

    The sub:

    Please Login or Register  to view this content.
    Can anyone suggest a solution to this problem or maybe a better way to do it?

    Cheers,
    Marcus

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,374

    Re: runtime Automation Error -2147417848

    Not sure that your code snippet is causing the issue...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2016 (Office 365)
    Posts
    137

    Re: runtime Automation Error -2147417848

    Thanks Sintek, I'll give that a shot. The error in my code occurs at this line:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2016 (Office 365)
    Posts
    137

    Re: runtime Automation Error -2147417848

    Some more info after lots of trouble shooting:

    I have noticed that this error occurs after I have entered some information into a table on a worksheet via a userform. It seems to leave some problem within the table that is only discovered when I run a macro, even though the macro has not yet had to interact with the table in question. This causes the automation error and closes excel down. Once open again all works fine.

    It also seems to cause issues when trying to delete the just entered data from the table using the Delete -> Del Table Rows functionality. When I delete table rows after selecting the rows I just entered excel crashes. Once excel is reopened I can then delete the rows using the same technique with no problems.

    There seems to be some issue being held in the table that once tripped by any method closes excel down and then when reopened the problem has been rectified. If I manually close excel down and reopen the problem is still there, it does not clear until excel finds the problem and shuts itself down.

    Has anyone had an issue like this? Any suggestions?

    Cheers,
    Marcus

  5. #5
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2016 (Office 365)
    Posts
    137

    Re: runtime Automation Error -2147417848

    This was a combination of 3 userforms I was combining into one. I started from the top and re wrote all the code and now seems to be working properly. I suspected the error might be cause by passing user entered information between userfrom fields prior to writing them to a worksheet table. I changed the code to insert information from each userform field directly to the worksheet table and all the problems seem to have resolved.

    Cheers,
    Marcus
    Last edited by demarc; 03-16-2019 at 08:31 PM.

+ 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. error Runtime 2147417848(80010108)
    By shilva in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2017, 02:01 PM
  2. run-time error '2147417848 (80010108)': Automation error
    By YounesB3 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-28-2014, 02:29 PM
  3. automation error the object invoked -2147417848
    By Proteo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2014, 08:57 AM
  4. run-time error '-2147417848 (80010108)': Automation error
    By BMaise12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2013, 03:19 PM
  5. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  6. Run-time error '-2147417848 (80010108)': Automation error
    By Lightboxes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2012, 05:53 PM
  7. Runtime Error -2147417848 (80010108)
    By dalian1803@yahoo.fr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2006, 02:10 PM

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