To get around the lack of multi-threading in Excel, I am using multiple instances of Excel Applications. One instance is controlling the other instances via VBA but I would like to be able to check if an instance is done running a macro. I have read that the Application.Ready method is not all that reliable and from what I can tell, it returns true even though the instance is running a macro.
Is there something else I can use to determine if an Excel instance is busy running a macro?
If I attempt to run a macro on an instance that is already busy running a macro using application.run method, it seems to just ignore the call and skip over it. I would like the main instance to wait until one of the instances becomes idle before continuing.
Thanks
Bookmarks