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.
Please add this feature!
Fonction serait bienvenue
Yes, please allow .xslm file.
I have a macro that cleans the template, because flow doesn't allow me to clear blank rows. Allowing to use a macro file is really necessary, please look into this.
Here's a fix.
@MaroonPorcupine @Julyapp1 @MikeHod @DanielVegaG @Rick_Jordan @NGarman
My fix here
Thank you - I am trying to manipulate an excel file with macros through power automate. I don't think this fix works for me, as I'm not necessarily connecting to MS Forms.
Another vote for this and a question?
This was first mentioned in 2017 but is still marked "NEW" how long till people usually see any action of this type of thing?
Also wondering. I really need to work with xlsm.
Any updates on this yet.. got the same problem.
This functionality would be amazing!!! Please add!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.