D
Don B
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.
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.