Feb 18 2019 07:49 AM
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.