Steps to schedule a macro to run daily automatically with sample code & setup scripts. Try this and test run by scheduling any VBA macro run automatically
Run Macro from Another Workbook – Excel VBA
November 22, 2021
Get code snippet to run macro from another workbook using Excel VBA command. This command works like a remote control to run VBA code in remote file.
