Multiple excel file manipulation

Help Something Else
1

Hello team!

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).

Thank you

2

Hi @LZlz15

Yes, It is best way to use macros.Because, We have multiple data manipulations and formulae involving in it.

By using the macros the code will run within seconds as expected without changing the formulae
Large data can also worked with macros without reading the excel.

Hope it helps!!

3

Hi @LZlz15

Can You provide the input data and expected ouput

4

Thank you!

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?

5

@LZlz15

Yes,

Invoke VBA is the activity to be used.
It needs a notepad with macros code and the method name in the macros code should be passed in the activity.

The output can be appeared in the current excel which is in use excel

image
image1170×1031 52.5 KB

Hope it helps!!

1 Like
6

@LZlz15

Refer the below video and docs for more info

Hope it helps!!

1 Like
7

@LZlz15

Happy automation!!

1 Like
8

@LZlz15

  1. You can do these maniiulations…
  2. Invoke vba or execute macro will help in triggering macros in excel
  3. Please explore excel activities that are present to understand what might help in manipulations according to your requirement
  4. 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

Hope this helps

Cheers

1 Like
9

What should I specify in the target workbook field?

10

@LZlz15

Just write the excel handle name you see in use excel file…generally it is Excel

cheers

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.