Topic Thread

Expand all | Collapse all

Create New Actions in Excel VBO using Excel Macro Codes

  • 1.  Create New Actions in Excel VBO using Excel Macro Codes

    Posted 05-26-2020 18:58
    Hi,
    I tried to create new Actions within Excel VBO using the code which generates from Excel macro. There were some component can't execute as it is. There were some replacement need to done in code level to execute the same. How can I study those code level miss matches and over come the issue arise in between Excel Macro codes and acceptable code in Excel VBO of the Blue Prism.

    Thanks

    ------------------------------
    Sameera Sandaruwan
    Banker
    Sampath Bank PLC
    Asia/Colombo
    ------------------------------


  • 2.  RE: Create New Actions in Excel VBO using Excel Macro Codes

    Posted 05-27-2020 11:05
    Hi Sameera, Excel macro code (VBA) and BP code stages (.net) will be similar but not identical - you can't simply copy and paste. As you will have seen, a BP code stage is not a particularly friendly editor - it's always been intended as a means of executing code snippets, rather than as a full IDE. So if you've got something tricky to debug, it might be worth developing the code in a real IDE and then putting it back into BP once it's perfected.

    ------------------------------
    John Carter
    Professional Services
    Blue Prism
    ------------------------------