automation error

I am completely baffled by these errors I am getting. Below is a short snippet of my code. I am using 2 separate workbooks to fill comboboxes in a userform. One of the workbooks is already open, so I am opening the other and reading info from it. Set wb =...

Hi All, I am very much confused by this error. I have a user defined function in my workbook. It runs fine usually however when I open my workbook an error is displayed "Automation Error" I click ok and it enters debug mode on my UDF. if i make the udf refresh it works fine. My UDF is in a...

Hi, I have a problem with a vba project created some time ago. The project contains multiple userforms. On open a userform is shown, and based on some simple choices another userform is loaded. This is when the project gives the following error: Run-time error '21474178 (80010108)'...

Hey fellas, so the idea here is doing a sort of a giant set of data in a seperate workbook. Leading up to this point in the code we have xlSht defined as a sheet object, getXcoX is an integer. Last is a little routine to get the desired endpoint. I know for a fact that xlSht and getXcoX are...

hi all, I have created a userform and during runtime i am adding few controls (basically labels and multipages)to the userform. While i am running the code i am getting the "RunTime Error '-2147217848(80010108)' Automation error The object invoked has disconnected from its clients." When i...

Hi MrExcel members, I am new to the VB Scripting and this is my first ever post on any forums:). Ok here i go with my problem - I have written one macro which sends automatic email notification when certain condition is not fulfilled. This macro basically tracks a particular activity to...

I am running Office 2003 and I am receiving the error message: Automation error: Object invoked has disconnected from its clients when I try to run the VBA code below. The code repeatedly copies a worksheet that contains 6 charts to individual workbooks, saving each one as it goes. Each...

I have this error, it is the first time I have experienced it after several successful executions of this program. The error is this: Run-time error '-2147417848(80010108)': Automation error The object invoked has disconnected from its clients. The basic function of this macro is to run a two...

I have been working on a project which requires me to populate a webform from Excel. I have managed to get this working 90% of the time. The other 10% I'm getting an automation error Run-time error '-2147417848 (80010108)': Automation Error The object involked has disconnected from its...