ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Waiting for app to complete OLE action (https://www.excelbanter.com/excel-programming/278584-waiting-app-complete-ole-action.html)

Don B[_3_]

Waiting for app to complete OLE action
 
I have an Excel VB macro that accesses another software
through the other software's ActiveX DLL. (The macro
includes statements that initiate operations in, and
access data from, the other software using that
software's object model.) After one such macro command,
I receive an Excel message that "Microsoft is waiting for
another application to complete an OLE action."

In order to allow the macro to continue, I have to
click "OK" on this MS message. I'd like to be able to
trap this error, if it is an error, so that the macro can
continue uninterrupted.


All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com