1,514 questions
Automate VBA refresh of Sharepoint Online Document excel file
Matt
1
Reputation point
Excel file uploaded to Sharepoint Online document libarary
The file has VBA which when executed refreshes an embedded Microsoft Query (linked to ERP database)
I need to set a schedule for the file to be refreshed daily. I'm looking for directions on how to do this. I'm agnostic as to how (eg Task Scheduler w/ Python, using a SPO built in function, etc)
Thanks in advance!
Developer technologies | Visual Basic for Applications
Sign in to answer