View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don B[_3_] Don B[_3_] is offline
external usenet poster
 
Posts: 3
Default 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.