Articles → AUTOMATION ANYWHERE → Pass Parameters In VBA File Using Automation Anywhere And Return A Value

Pass Parameters In VBA File Using Automation Anywhere And Return A Value

VBA File

1. Open notepad or any other text editor.
2. Save it with test.vbs.
3. Write following code in test.vbs

' Input parameters
MsgBox WScript.Arguments.Item(0)
MsgBox WScript.Arguments.Item(1)

' returning  value
WScript.StdOut.WriteLine WScript.Arguments.Item(0) & WScript.Arguments.Item(1)

Automation Anywhere Code

1. Drag and drop ‘Run Script’ and add following parameters

Click to Enlarge

Here $test$ is a local variable that will hold return value. Input parameters are passed in double quotes separated by space.


2. Display the return value using message box

Click to Enlarge

Output