Infuse Macros in Excel into BluePrism

Question

I have recently created a VBA Macro which allows the sorting of data based on columns. However, I am unsure of how to infuse this into the BluePrism or to modify the code into BluePrism as I am very new to BP. Any help will be appreciated.

Also apart from coding is there another approach which allows me to integrate the VBA macro code into BluePrism?

Answer 1

as you know you can't use Excel VBA code directly in to Blue Prism.

With the Excel sheet in question open and Blue Prism attached to the running instance of Excel, perform thi

Select an Action stage.the select MS Excel VBO in the Business Object drop-down.and select the "Run Macro" in the Action drop down.

From inside this stage you can call the Macro by its given name.