cancel
Showing results for 
Search instead for 
Did you mean: 

Enable actions on macro-enabled files

See original post here: https://powerusers.microsoft.com/t5/Building-Flows/Update-macro-enabled-Excel-file/m-p/59123 

 

We cannot do actions such as "insert row", "delete row" etc. on macro-enabled files. 

 

We can try working around by updating files with the "File content" data from an edited Excel file, but since it's not the same format, the target .xlsm file gets corrupted. 

 

Allowing for selecting macro-enabled files and for updating them from the content of non-macro-enabled files would be helpful. 

Status: New
Comments
Regular Visitor

That would indeed be great

Advocate I

I have a flow that exports data from Forms to Excel. I want to have that master sheet copy to weekly report sheets, but that requires a macro, and Flow can't use anything but .xlsx.  

New Member

agreed, please add this functionality 

New Member

I would love it if flows could be used to update a .xlsm file. I don't need it to run a macro, just insert a row into a file that has macros. Then my users can download the updated file from OneDrive and run the macro via a button in the file. Otherwise I'm jumping through too many hoops to create an automated task.

New Member

This would be brilliant.  Ideally, it'd work for both .xlsm and .xlsb files.  

 

The inability to add rows into macro-enabled workbooks is really diminishing the value of Flow for me at the moment.

New Member

This is exactly the problem I'm encountering, it seems bizarre to be able to update xlsx but not xlsm. Please fix!

Regular Visitor

Could really use this functionality. Any update on when it will be implemented?

Helper II

I can't even seem to be able to "get a row" from a xlsm file.  Very frustrating!

 

What I want to use the flow for is to extract rows from the macro enabled file into non-macroenabled files for others to use without the processing overhead within the file.

Anonymous
Not applicable

Is Microsoft planning to implement this functionality in a near future?

  • to be able to assign a trigger or action flow to xlsm file.

It would be nice to know Smiley Happy

New Member

This would indeed be very useful! Any update yet?