A project that involves multiple files with macros as its foundation, and multiple files where data needs to be processed through these macros and then analyzed—can this be done using UiPath technology? Is it recommended? Or should another solution be sought?
This project involves a lot of formulas(in excel) for analysis. There are many data points (columns and rows).
What activities are used in UiPath for macros?
And then those data resulting from macros need to be analyzed again in complex Excel files with many formulas. Can this be done with the help of UiPath activities? If yes, which ones?
Invoke vba or execute macro will help in triggering macros in excel
Please explore excel activities that are present to understand what might help in manipulations according to your requirement
While using macros be user not to use any message box or suppress all the alerts and have proper error handling in macro else if macro fails the bot gets stuck over there to avoid those scenarios please follow above cautions