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.
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.
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.
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
The above can be acheived and automayed by the following steps , below is the workaround
In the Macro Enabled Excel Sheet Add another Macro to Save the File as
ActiveWorkbook.SaveAs Filename:= _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=True
This will save the file as a Non Macro Excel File on a Sharepoint or Onedrive Site
Use a Power Shell Query to update the Macro enable Excel file and save on
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.
Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Fill out a quick form to claim your user group badge now!
Check out the new Microsoft Flow Community Blog Topic Suggestion board!
Learn how to build the business apps that you need
Find out where you can attend!
Watch & learn from the Flow Community Video Gallery!