Hi. I wanted to ask if there is a way to detect that a macro has completed (by
completing, an error stopping the macro also counts). I have a VB application
that calls an Excel macro. The Excel macro makes a text file that the VB application
needs to continue, so the VB has to wawit before continuing.

In pseucode, i've done this waiting with a tight loop:

call the macro

While file_i'm_waiting_for doesn't exist
Wend

continue doing what i was doing

The tight loop gets what I need done in good situations, but for example,
if the macro experienced some kind of error that prevented it from completing
making the text file, the VB app will sit in that tight loop forever and just
hang. Isn't there some better way to detect that the macro is completed?
Like some property I can check, e.g. using While WB.active = True instead
of checking that the file exists. (I just made that "active" property up, but you know what I mean).

Thanks.