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.
Needed this today. Any update?
Same here. Excel has a simple button to hide show columns, so its a .xlsm. But cant add it to my flow (add new column). Please add this feature!!!
same problem 😞
This would indeed be very useful! Any update yet?
I have just come up across this very issue. Why cannot you connect / select in a Flow an excel macro file .xlsm?Please add this functionality as soon as possible.Best Regards
Sadly and Objectively, I'm guessing Microsoft won't give much of a crap about .xlsm macro files, because Office Scripts are slowly (slowlyyyy) making their way and would technically remove the future need for VBA/xlsm.
Quite sad, because it makes Power Automates very useless for a bunch of companies that already have very functional xlsm business processes.
Right now, the absence of .xlsm support is the no1 reason my company and acquaintances don't touch Power Automate, since we cant use the "Get tables" function out of the macro files.
And I would consider converting to Office Scripts, since MS isn't supporting the legacy macro files, but the last time I checked Office Scripts just doesn't compete.
Namely, my current programs rely on a lot of PDF creation and Outlook email messaging, but a quick look at Office Scripts API informs me it doesn't handle Outlook.