About macro enabled excel files in Excel (Business) in Logic Apps

Question

I want to process a macro enabled excel file (.xlsm) in Excel (Business) in the Logic application, but I cannot load the file.

I have selected the get worksheet action in onedrive, but does that still mean I can't read the macro enabled excel file?

Will the macro enabled excel file be script only?

Answer 1

Hi @NishimuraChinatsu-9854 ,

Thanks for reaching out to Q&A forum.

You can use the Runscript action to load a macro(.xlsm) file from one drive. You can try to start the macro by some external script and it can be passed in the script section. If the VBA code in the macro file is placed in the Workbook_Open() method, then this approach would work.

Hope this helps! Feel free to reach out to me if you have any questions or concerns.