cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ffritz
Advocate II
Advocate II

Run Excel Macro

Hi,

is it possible to execute an Excel Macro via flow for a Excel Document stored on OneDrive/Sharepiont Online or otherwise?

I could not find any activity for that.

Thx

Fritz

24 REPLIES 24
Frank6
Microsoft
Microsoft

Microsoft supports running office script on online excel through Power Automate.

https://docs.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration

Hi @Frank6 ,

Yes I have now looked at office script, but it is limited to Excel and the VBA I call creates Powerpoint slides from data in Excel, so my requirement still stands.

thanks for your reply.

 

 

Paulie78
Super User
Super User

I can't see this ever happening, it simply does not fit within the design principles of the product and I can't see how it can be practically achieved.

 

There are ways you could already do this:

  • Use an RPA flow to execute your desired actions in Excel.
  • Use a scheduled task on a desktop to check for the existence of a "trigger file". That fires up Excel and executes a macro (Powershell or VBScript)

I already had a good understanding of how Excel was embedded in organisations, but more time I spend on these forums the more I realise that it goes deeper than I thought.

Many of the Excel related questions that come up here could be easily solved by not using Excel at all. But of course there are exception.

As this macro requirement is so often requested I might write up my methods that make this possible.

ShaileshMehta
Frequent Visitor

I am also looking to have this feature.

Kingcup
New Member

Hi this is now 2021 so is this supported? I am having hard time using desktop flow to run the macro every minute to find out which of my items are in queue and use teams to alert me. I think that allowing my macro to run with flow would allow me to get this done.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,265)