I am trying to develop a bot for my organization that invokes an Excel VBA macro stored in a txt file. Unfortunately, the default settings on my organization’s computers is for macros to be disabled in the trust center settings within excel.
I have tried using the invoke macro activity but have not had any success. I assume it is because of the security settings. Is there any way to work around this?
Is there a way to use UIPath to enable macros on an active workbook? Additionally, I would like the macro to run on workbooks that are xlsx and xlsb files.
I don’t think there’s another way but to create a workflow that if you get the error the open excel and disable it using clicks and that stuff. Just a simple task. It’s not that hard, give it a try.