Search code examples
blueprismrpa

BluePrism Running An Excel Macro with User input

Right now I have an issue with an Excel Macro where it takes an input from the user.

Current process is: Create Instance -> Open Workbook -> Run Macro The process is stuck at "Run Macro" and is unable to be "detached" for further actions.

Any tips and tricks?

screen shots: macro code

macro requiring user input

Solution

  • Well, when you're running excel VBA code, then the BluePrism will wait until the code will be finished.

    That means that you should not run a code like that using BluePrism, as it's sure way to lock your process. The process will wait for VBA to finish, and VBA will wait for user.

    If you'd like to interact with interface that VBA presents, then I can advise you one of the following things:

    • Rebuild the VBA code, so that the parameters are passed from the BluePrism and so that there are no pop-up windows
    • Start the VBA code using any spying technologies - for example create a UI button that will be clicked by BluePrism