Hi I am a bit new to this I am downloading one XLS file from the internet and it saves in a particular folder Now I have XLSM file which i have in that folder that XLSM file contains a script to work on any active-workbook When I manually open the file I can run the macro but when power automate opens the file it doesnt show any macro I am stuck on this
Any Help Would Work, Thanks
Power Automate cannot run VBA code. You must create an Office Script and call that against your newly downloaded workbook (which MUST be in a format Excel-online can open). See my page on Office Script for some pointers: https://jkp-ads.com/articles/excel-office-script-examples.asp