schedule and run an excel macro within alteryx

Question

I have a macro for a file which downloads large quantities of data from various servers (Alteryx will not have access to these servers) and rolls the file to the new business day. This acts as an input file before some analysis is done on it and then an output file is generated. There are multiple files of this nature in which someone has to wake up at 6.20am each morning to click a button to kick off each macro. This is a task that takes atleast an hr

Is there a way Alteryx can be automatically scheduled to run these macros (from excel) and gather the data into alteryx as a set of input files?

Regards

binu_acs · Accepted Answer

@Max_Ocean The below post might be helpful for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel-Macros-VBA/ta-p/471551

Max_Ocean · Accepted Answer

i could use this to run macros to source data Alteryx doesnt have access to directly? and I can then schedule it?