Execute Macro and Pass Parameter - Solution

[SrenivasanKanna (Srenivasan kannan)]

Hi All,

Here are the steps to use Execute macro with parameter

I wish to add a number with macro code contains numbers.

Process Step:

step 1: creates a macro file with the below code.

Step 2: Use input Dialogue box to enter your number and create var B to store it.

Step 3: use Execute macro activity and provide the macro name into an activity box. Then in the property panel on the macro parameters tab pass your arguments like below.

VBA Code :

Happy Automation!

[Pradeep_Shiv]

Thats great,this will help
Cheers @SrenivasanKanna