Is it possible to run a parameterized excel macro in Blue Prism?
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-08-17 12:00 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-08-17 07:24 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-09-18 02:30 PM
Hi Srinivasan__Iyengar,
Can you share the code please, if done?
