I am trying to automate one of our reports at work. Unfortunately the report has macros and i was wonderding if any of you has come across such an event. In my automation I am using excel application Scope. I have tried using Execute macro activity but to no avail. I maybe missing a step. Has any of you interacted with linking excel macros to UI Path??
Thank you for your reply. I have fount the activity and used the execute macro activity. However, an error message keeps popping up. I put the macr name in quotation marks but that doesn’t work either
No, every macro contains a Sub Name_Of_The_Macro ()
The Name_Of_The_Macro is what you need to put in the run macro activity . The path of the excel containing the macro should be written in the Excel application scope.
If you have any more issues send me the xaml and I’ll try to help you as much as possible.