Question
How does the user closing an Excel workbook trigger this error?
Asked by: USER1394
63 Viewed
63 Answers
Answer (63)
When a user closes an Excel workbook, the Excel application often terminates the connections to all open COM objects. If your VBA code is still referencing those objects, it will encounter the 'disconnected object' error when it tries to access them after the workbook is closed.