How to pass argument in Excel Macro

[Anonymous]

Hi, I want to use a macro where I want to pass some value to it. I have tried 'run macro' action of 'MS Excel-VBO' but couldn't do this. Please suggest me the solution.

[NilsZwart]

Hi Mohd.daud, I didn`t had any troubles using the Run Macro action of the MS Excel-VBO. Make sure the macro`s name is exact and written as a tekst. "" "" -Nils-  

[Hitesh__Mhatre]

Hi, There is a way I used for my project. If you able to edit macro then edit your macro such way that you pickup arguments from respective cell (Consider you pick value from Cell A1). Later you try to write arguments in excel sheet (write your argument at A1 cell) and run macro using BP. In this way you can pass arguments and run macro. I hope this will help your problem. :)

[DeepakGoyal1]

Hi Hitesh__Mhatre We already did this, is there any way to pass parameter with macro's name in function Run Macro?