Excel Macro with Userform taking an hour

[Julius_RobinMur]

Hello! We've been troubleshooting a robot processing an Excel macro with userform.

This is how the macro works. The macro is executed and a userform shows up. Options are chosen and a "Process" button is clicked to go to the next userform. After choosing the options on the second form and clicking a "Continue" button, the macro then generates a new Excel file that contains Pricing Sheets.

If this is done manually by a user, the whole process takes 7-10 minutes. However, if this same procedure is done by the robot, the whole process runs for an hour but no new Excel files are generated.

I have monitored the bot and I can confirm that the bot does follow the click procedures. The machine is also not showing any signs of huge memory/CPU consumption.

Kindly advise what we need to do to fix this.

------------------------------
Julius Robin Murallon
Subject Matter Expert
IBM Global
Asia/Manila
------------------------------

[ritansh.jatwani]

Hello @Julius Robin Murallon,

I am assuming that UI automation has been performed on the userform by spying the screens. Did you try directly calling the macro and passing relevant parameters from Blue Prism? It will be a much faster approach.​

------------------------------
Ritansh Jatwani
Consultant
EY
Gurgaon
------------------------------

[Julius_RobinMur]

Hi Ritans,

That is correct.

The problem lies upon the length that the macro is running rather than the buttons being clicked. The macro is called using the "Run Macro" command and the buttons on the userform were spied through Application Modeller. The bot is successful in both running the macro and clicking the buttons.

The problem is that when the bot finishes the whole macro and userform clicking, Excel takes so much time generating the new file. But if the process was done manually, Excel takes only minutes.

Is there something between the CPU utilization, memory consumption, or Blue Prism integration that we missed?

Please note that the option to optimize the macro has already been done and that the macro should not be modified further as multiple teams use the macros within the Excel.

------------------------------
Julius Robin Murallon
Subject Matter Expert
IBM Global
Asia/Manila
------------------------------

[ritansh.jatwani]

Hi @Julius Robin Murallon,

Optimizing macro won't help much since you said running it manually is taking just minutes and with automation, it is taking much more time which ideally should not happen since the bot just imitates the human steps. Have you observed the memory utilization during the macro running?

Does the macro interacts with any file which is placed on some shared network drives or on local drive since the speed might get reduced due to some network failures as well.​​

------------------------------
Ritansh Jatwani
Consultant
EY
Gurgaon
------------------------------

[PvD_SE]

Hi Julius, 

Is there a lot of data in the Excel for BP to handle? How many rows and columns does it have?

------------------------------
Happy coding!
Paul
Sweden
------------------------------