Here are the steps to use Execute macro with parameter
I wish to add a number with macro code contains numbers.
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 :