Hi,
I am using Excel activities, using macros. Suddenly “Save workbook” stopped working. I find an alert on Excel to save as macro enabled workbook. So instead of giving .xlsx extension, I am giving .xlsm. But now the bot cannot open .xlsm file. I cannot open it manually either. When I try to open manually, I get an alert that the format is invalid. How can I resolve this issue?
Thank you so much,
Hi @A_Learner
Did you give like this only. Please specify are you using Modern activities or Classic activities. Save Workbook is working fine at my end.
Hope it helps!!
Thank you. I am using macros in the Excel. I find an alert saying that “VBA project must be saved in macro enabled workbooks.” So if I tried saving the file as .xlsm instead of .xlsx.
The file with .xlsm cannot be opened from the .xaml or manually. What is the work around for this?
Thank you,
Hi @A_Learner
If you use VBA Macros too you can save it with the extension .xlsx. Actually it shouldn’t throw any error.
Regards