cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

MrAnalytics
Brass Contributor

‎May 12 2022 09:05 PM

‎May 12 2022 09:05 PM

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

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: https://www.youtube.com/watch?v=u6ppPk3r0T0  

See the full demo here: https://www.youtube.com/watch?v=owI4LyQb2xE

You comments are welcome. 

 

Refresh Data Connections for Excel Online
Refresh Data Connections for Excel Online
youtube.com/watch?v=u6ppPk3r0T0
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 : https://www.youtube.com/watch?v=owI4LyQb2xE
Run VBA on SharePoint Online for Excel files
Run VBA on SharePoint Online for Excel files
youtube.com/watch?v=owI4LyQb2xE
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: https://github.com/MrAnalyticals/Power-Automate/tree/main/VBAonSPO Tools used to run VBA on SPO are : Power Automate Cloud and Desktop ...
Labels:
28.5K Views
0 Likes
0 Replies
Reply
0 Replies