Hello Community,
I am using .xlsm file for my automation, In our Prod server there is no excel installed, We can’t use Excel scope. Is there any code to remove macro from original file and use workbook activity?
Thanks,
Chiranjit
Hello Community,
I am using .xlsm file for my automation, In our Prod server there is no excel installed, We can’t use Excel scope. Is there any code to remove macro from original file and use workbook activity?
Thanks,
Chiranjit
Hello @ch460960
If Excel is not installed in your Production environment, you could use the Workbook Activities that are available in the System category of the Activities panel in Studio.
Refer to the following link for more details :
Cheers
If your production server don’t have excel installed then you cannot read .xlsm file as workbook activities only works with .xls & .xlsx
In short you cannot run the Macro without Microsoft Office installed.
Thanks,
Ashok