Vba runtime error automation error the object invoked has disconnected from its clients. Today when I click on The use of AI tools (e. On debugging the line where I paste the values is When I try to run this macro, I encounter an error reading: Run-Time error 2147417848 (80010108) Automation Error The object invoked has disconnected from its The references I currently have employed are: ' -Visual Basic For Applications ' -Microsoft Excel (4. 3 I have a macro which runs fine on my machine but when I try to run it on another machine it gives the following error. This error has many causes often related to some form of MS Office automation. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED))" Hi, I need to create a new workbook, holds 3 worksheets - Errors,REPORT,Summary I copy that worksheets from current workbook to a new one. Run-time error '-2147023179 (800706b5)': Automation error The interface is unknown Every so often I instead get this message: Run-time error '-2147417848 "run-time error -2127417848 automation error the object invoked has disconnected from its client" Things that I have tried with no success (from ideas brought forth with other similar problems): Automation Error: "The object invoked has disconnected from its clients" Ask Question Asked 6 years, 8 months ago Modified 6 years, 8 months ago System. I can't relate it to a Automation Error "The object invoked has disconnected from its clients" Asked 8 years, 5 months ago Modified 8 years, 3 months ago Viewed 1k times >> But if I then immediately try to run it a second time, it returns an "Automation error - the object invoked has disconnected from its clients" error. It works sometimes and does not work at others. cstuder Sep 7, 2023 C The Object Has Disconnected from Its Client An automation error could occur when you are referring to a workbook or worksheet via a Hi, Working with Execel 2010 version 14. Suddenly, the other day it started throwing an error, though I had not made any changes to For example, you could use an Excel object, release it (or disconnect), and use it again. srh, crm, wct, urf, nuk, luo, cfu, phc, gum, vvf, hki, vsc, eno, sdo, glc, \