cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to run a parameterized excel macro in Blue Prism?

Anonymous
Not applicable
I have used the MS Excel VBO's Run Macro Action to run macros in Excel and I wanted to know if it's possible to run macros that take parameters. If not, would it be possible to code this in the code stage?
2 REPLIES 2

Anonymous
Not applicable
The original MS Excel VBO Run Macro does not have, in its present form, that possibility. You need to edit or create a new action that allows you to pass parameters. You can either hard-code the number of parameters you want your macro to take or you can give your code stage a Collection, turn it into an array and pass it as a variant. This way you will have a more generic action and you can pass as many parameters as you want, although you would need to remember to ""handle"" the array inside the macro.

PoojaSabharwal
Level 2
Hi Srinivasan__Iyengar, Can you share the code please, if done?