Blue Prism Product

last person joined: 2 days ago 

Chat about Blue Prism products
Expand all | Collapse all

Excel Macro with Userform taking an hour

  • 1.  Excel Macro with Userform taking an hour

    Posted 01-21-2021 19:31
    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
    ------------------------------


  • 2.  RE: Excel Macro with Userform taking an hour

    Posted 01-25-2021 15:19
    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
    ------------------------------



  • 3.  RE: Excel Macro with Userform taking an hour

    Posted 01-26-2021 01:56
    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
    ------------------------------



  • 4.  RE: Excel Macro with Userform taking an hour

    Posted 01-26-2021 15:36

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



  • 5.  RE: Excel Macro with Userform taking an hour

    Posted 30 days ago
    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
    ------------------------------



FAQ

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.



Share this post