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

MrOptimistic

 

You may well be right with script but I think this will take several years to become the replacement for VBA as Macros are so well entrenched in companies.

I have got round this issue by creating a form via excel which auto links the form data as / when submitted and then I have a second excel file which on opening auto macros a copy from the form linked file to a data sheet in the analysis file and then can run say pivot table refresh etc.  Hope you find this of interest.

 

Mike H 

Regular Visitor

Hi @MikeHod ,

 

Could you elaborate on that please? Sounds like something I've been trying to do but never found any good tutorials on how this would work, I would need to have Data from e.g. Microsoft Forms or Jotform saved to a list and the same data being used in an Excel template where the data would be filled out in certain cells.

 

Thanks in advance.

 

Daniel

Regular Visitor

@DanielVegaG

 

please send connection request on LinkedIn and I will then be able to discuss and explain potential solution.  

best regards

 

Mike H

 

linkedin.com/in/mike1hodkinson

Regular Visitor

This is a VERY good idea - cannot believe this wasn't added from the get-go. 

Macro's are the backbone of Excel in my opinion. 

New Member

Friends, I believe we might have some work to do outside of Excel / VBA / OfficeScripts...

 

With the announcement of Microsoft Lists at Build 2020, I feel like a lot of previous Excel VBA macros handling data will find a worthy successor in that project. From forms to automation, I can't wait to put my hands on that app and test it out.