Wait if application open

[astrikor]

I am trying to run two auto macros (in different files) one after the other where the run times are unknown. Both macros conclude with "application.quit" I need a function which will allow the second macro start immediately after the first has closed Excel. Is there any means in vba of determining if excel is already open when starting the second file ? Something like "wait if application already open" ?

Any ideas welcome!

Thanks
Astrikor

[Leith Ross]

Hello astrikor,

This macro will allow you to start another application, and resume running your macro after the application closes.

Please Login or Register  to view this content.

Macro Example

Please Login or Register  to view this content.

[astrikor]

Thanks Leith,

It's a solution which I have tried and it works, but as it's beyond my understanding I am reluctant to use it.

I was hoping for something simpler - I am aware of the Hauppauge VTPlus Script for example:

Please Login or Register  to view this content.

This simply waits until the application has been executed and closed before moving on to a subsequent instruction
(which could be repeats of this code using different filepaths)

I could use this approach, but would prefer to stay within excel.

Any comments ?

Astrikor

[Leith Ross]

Hello astrikor,

Excel does not support this feature natively. You will have to use an outside method.