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.
Is any of this feasible?