Run Excel Macro

[ffritz]

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

[Frank6]

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

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

[Gareth-]

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]

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]

I am also looking to have this feature.

[Kingcup]

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]

A YES PLEASE for 2022.