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.
It's been 2 years since posting. Any updates? I would really need that function to work. Microsoft please do it.
Excel with macros should be generelly supported in the cloud, although I know it might cause some issues as the "cloud" is not "Windows". But as a first step, of course: voted!
Really need flow work with macro-enabled Excel. I can't skip macro as part of the data updating function.