Eliminating Excel macros from my production environment

Help Studio
1

I’m looking for guidance on eliminating Excel macros from my production environment.

Currently, several of my UiPath bots depend heavily on VBA macros. These macros handle large datasets, including operations such as pivot table creation, complex calculations, data transformations, and formatting. However, due to security and stability concerns, I want to completely remove macro usage from my production server.

I would like to understand the best approach to achieve this transition.

Specifically:

  • What are the recommended UiPath alternatives for handling large datasets efficiently (especially for pivoting and calculations)?

  • Is it better to replace macros with:

    • UiPath Excel activities (Modern/Classic),

    • LINQ / VB.NET in Invoke Code,

    • Or external scripts (e.g., Python, .NET libraries)?

  • How can I replicate advanced Excel features like pivot tables and heavy formatting without using macros?

  • Are there any performance considerations or best practices when dealing with large volumes of data?

  • Has anyone successfully migrated from macro-based automation to a macro-free architecture in UiPath? If yes, what approach worked best?

Any guidance, architecture suggestions, or real-world experiences would be highly appreciated.

2

@shifa.shaikh3

Few things that we did to eliminate

  1. create a template with all the pivots in it already
  2. include the formatting upfront using conditional formatting
  3. If conditional formatting does not suffice then use set range color

then use change data source activity to update the range in pivots

cheers