Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
I have an Excel application where this error pops up. It is a fairly large application in terms of code but is not really complicated. I run code from buttons on userforms. This code generally opens one or more other workbooks, extracts/updates information from these workbooks, closes them, and exits. I am not opening other applications.
At the end of a button_click event procedure I get err/description "-2147417848 Automation error The object invoked has been disconnected from its clients". The proc opens a workbook, finds a record in that workbook, loads the fields of the userform accordingly, and closes the workbook. Strangely, the code appears to do everything it should, just this error at the end, apparently at the Exit statement..The only negative impact (aside from the message) seems to be that the ctrl-break stops working. Does anyone have any information about this for me? I am going crazy and my deadline is fast approaching. Can I just ignore the error? As I said, the code appears to complete successfully with no visible impact except the error message and the ctrl-break no longer working. Please help! David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation Error
It happens that mondrogan formulated :
I have an Excel application where this error pops up. It is a fairly large application in terms of code but is not really complicated. I run code from buttons on userforms. This code generally opens one or more other workbooks, extracts/updates information from these workbooks, closes them, and exits. I am not opening other applications. At the end of a button_click event procedure I get err/description "-2147417848 Automation error The object invoked has been disconnected from its clients". The proc opens a workbook, finds a record in that workbook, loads the fields of the userform accordingly, and closes the workbook. Strangely, the code appears to do everything it should, just this error at the end, apparently at the Exit statement..The only negative impact (aside from the message) seems to be that the ctrl-break stops working. Does anyone have any information about this for me? I am going crazy and my deadline is fast approaching. Can I just ignore the error? As I said, the code appears to complete successfully with no visible impact except the error message and the ctrl-break no longer working. Please help! David How are you accessing the data? If using an ADODB data object then you must destroy the object before you close the file being accessed by it. Not sure why you're opening each workbook anyway, since ADO can grab the data without having to open the actual workbook in Excel. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '-2147221080 (800401a8)': Automation error | Excel Programming | |||
Compile error: Automation error in Excel 97 | Excel Programming | |||
Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error | Excel Programming | |||
Run-Time Error'-2147221080(800401a8)': Automation Error | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |