Automate VBA refresh of Sharepoint Online Document excel file

Matt 1 Reputation point
2022-12-15T20:52:39.723+00:00

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
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.