Execute Macro and Pass Parameter - Solution

Hi All,

Here are the steps to use Execute macro with parameter :slight_smile:

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

Process Step:
image

step 1: creates a macro file with the below code.
image
Step 2: Use input Dialogue box to enter your number and create var B to store it.
image

image

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.
image

image

VBA Code :
image
Happy Automation!

3 Likes

Thats great,this will help
Cheers @SrenivasanKanna

1 Like