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

25 REPLIES 25
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
Advocate I
Advocate I

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.

L-T_Emma
New Member

A YES PLEASE for 2022.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,067)