Forum Discussion

Project_buck's avatar
Project_buck
Copper Contributor
Feb 18, 2019

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

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.

No RepliesBe the first to reply

Resources