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

%3CLINGO-SUB%20id%3D%22lingo-sub-3368309%22%20slang%3D%22en-US%22%3EYou%20can%20use%20Power%20Automate%20Desktop%20to%20run%20VBA%20for%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3368309%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20video%20that%20demos%20how%20to%20use%20Power%20Automate%20Cloud%20and%20Desktop%20to%20trigger%20a%20VBA%20macro%20on%20a%20schedule%20in%20unattended%20mode%20on%20an%20Excel%20file%20resident%20on%20SharePoint%20Online%20(SPO).%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20VBA%20to%20refresh%20an%20external%20data%20query.%20So%2C%20this%20means%20you%20can%20refresh%20an%20external%20data%20query%20for%20an%20Excel%20file%20resident%20on%20SPO.%26nbsp%3B%3CBR%20%2F%3EUpdate%20%3A%20Microsoft%20has%20recently%20announced%20the%20part-enablement%20of%20Query%20Refreshing%20for%20Excel%20Online.%3C%2FP%3E%3CP%3ESee%20the%201%20minute%20intro%20video%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Du6ppPk3r0T0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Du6ppPk3r0T0%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20full%20demo%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DowI4LyQb2xE%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DowI4LyQb2xE%3C%2FA%3E%3C%2FP%3E%3CP%3EYou%20comments%20are%20welcome.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3368309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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: https://www.youtube.com/watch?v=u6ppPk3r0T0  

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

You comments are welcome. 

 

0 Replies