cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ffritz
Level: Powered On

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

15 REPLIES 15
Power Apps Staff ashwinsa
Power Apps Staff

Re: Run Excel Macro

Unfortunately not right now, we don't support execution of excel macro. But that is an amazing suggestion i will forward it to see if we can include it in our plans. Thanks a lot for reporting this.

Vishal-S
Level: Power Up

Re: Run Excel Macro

Add my vote in it too. Ned the ability to run the Macro within Excel.

Anonymous
Not applicable

Re: Run Excel Macro

I would like to see this functionality as well! I hope it gets added soon.

ET
Level: Power Up

Re: Run Excel Macro

I concur, could use this feature today!

Highlighted
emhanna
Level: Powered On

Re: Run Excel Macro

Yes, we need to be able to run macros from a Flow. But not just Excel macros. We need to be able to run any VBA macros.

 

Here is a real world example of why we need this--in this case for quickly and easily building automated interfaces. Accounting passes us an Excel file containing some data that we need to import into Microsoft Project. We want to first run a Cleanup macro in Excel--and then we want to run a Project macro to import the data. A perfect opportunity for Flow to add significant value!

 

So much power will be unleashed, if somebody gets at it and bakes this into the Flow Service. 

Novido
Level: Power Up

Re: Run Excel Macro

I also concur with the above! 

Being able to run macros will significantly increase the use of PowerApps.

 

Additionally I also want to see the ability to, with the help of macros, save (e.g. tables of data) as .csv files locally.

ludwig
Level: Powered On

Re: Run Excel Macro

Also add my vote. That's an important functionality that we need

Toasteroven
Level: Powered On

Re: Run Excel Macro

It has been two and a half years, any update???

StepanResl
Level: Powered On

Re: Run Excel Macro

Please, we really need it. 

GrahamTuffin
Level: Power Up

Re: Run Excel Macro

Echo all above, this would really help with process improvement and automation

JeffMcCabe
Level: Power Up

Re: Run Excel Macro

Agree with above.  Need to start modifying data mid-flow.  This will address a lot of hassle.

 

 

For those with challenges performing routine formatting macros to large quantities of flowed data, recommend creating a flow that leads data to static locations, then creating a master controller macro workbook that grabs files from those directories into an array, opens the latest workbook in those directories, applies the subformatting macro routine, then saves/closes the arrayed workbooks one by one.

 

You know.  Or Microsoft could simply add a cool new feature to call Macro/VBA code from OneDrive-stored Excel files.  Fairly simple to implement.  Would make a lot of us happy 🙂

Shaffy80
Level: Powered On

Re: Run Excel Macro

The above can be acheived and automayed by the following steps  , below is the workaround

 

Step 1

In the Macro Enabled Excel Sheet Add another Macro to Save the File as 

ActiveWorkbook.SaveAs Filename:= _
"filename" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=True

 

This will save the file as a Non Macro Excel File on a Sharepoint or Onedrive Site

 

Step 2

 

Use a Power Shell Query to update the Macro enable Excel file and save on 

 

Step 3

 

Use task scheduler to repeate the above process as per your required interval (Hourly/daily/Monthly etc)

 

 

Once the 3 steps are completed the your workbook is completely automated and can be connected to flow as any other excel file.

 

Thanks.

Gareth-
Level: Power Up

Re: Run Excel Macro

Definately needs this.  so this also means also that all flow actions that involve spreadsheets (adding a row to an existing table, etc., etc.,) need to support writing to macro enabled spreadsheets (*.xlsm) at the moment you can only write data from Flow to *.xls sheets.

 

This is extremely inconvienient and means for example in a process I wanted to automate e2e using Forms Flow Excel VBA and PowerPoint and Power BI  [ Forms data --> automatically generated pptx slide & Power BI report that links to the slide ], I have to get a human to open a macro enabled spreadsheet and run macro 1 which sucks data out of a .xls spreadsheet and then macro 2 which makes the powerpoint slides. Urgghhh.

 

Please please consider prioritising this capability,

Maddy
Level: Power Up

Re: Run Excel Macro

This would be very helpful.

Thinkbusiness
Level: Powered On

Re: Run Excel Macro

Together with the possibility to update an XLSM file (e.g. add row) the possibility to run an Excel Macro has been requested for over 2 years... That's either saying something about the speed improvements are made or saying it's not going to happen.

 

Instead of focusing on inventing new names such as "Power Automate" to feed the "Power Platform" marketing bubble - address some more resources to development of the product itself so important features can get developed.

 

My 2 cents...

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors
Users online (5,291)