You can use Power Automate Desktop to run VBA for Excel Online

Occasional Contributor

I created a video that demos how to use Power Automate Cloud and Desktop to trigger a VBA macro on a schedule in unattended mode on an Excel file resident on SharePoint Online (SPO). 

You can use VBA to refresh an external data query. So, this means you can refresh an external data query for an Excel file resident on SPO. 
Update : Microsoft has recently announced the part-enablement of Query Refreshing for Excel Online.

See the 1 minute intro video here:  

See the full demo here:

You comments are welcome. 


Refresh External Data Connections in Excel Online using VBA and Power Automate Cloud and Desktop. This info video introduces my longer video demo on how to use VBA on SharePoint resident Excel xlsm files. See the demo video here :
Run VBA on SharePoint Excel files using Power Automate. Run VBA macros on files resident on SharePoint or OneDrive. The GitHub resource for this video is here: Tools used to run VBA on SPO are : Power Automate Cloud and Desktop ...
0 Replies