Home

How to create a macro which autoruns after third party app update

Project_buck
Occasional Visitor

I have a file which, on open, auto downloads data from a third party application (via their macro).

I would then like another macro to auto run to copy/paste values all the data, save the file and close.

I have created a macro which does this if I manually run it, the problem is the third party macro runs on file-open and thus prevents my macro from running. I can't edit the third party macro to call mine afterwards. Is there another solution? Is there any way to e.g. create a batch file to open the excel file then pause for say 5 minutes (while it updates via the third party macro) and then run my macro? 

Any feedback would be appreciated.