26
Hi, i ve got excel on onedrive with macro which refresh my queries, tables and connections.
What i need to do is just to open this excel everyday at 6 am (macro run automatically).
I cant do that with PAD couse my computer is not always on, at 6 am.
Any ideas how to do it with PC offline?
MB
you'll need to get an unattended RPA license. Or look into Office Scripts (new web friendly macros) and see if the query refresh can be done there. But to open a file and run a refresh I think that has to be an unattended to where the file is opened by a bot on a virtual machine, refreshed and then saved and closed.
Share
Report
All responses (
Answers (
