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

In this article, we will pass parameters in VBA file using automation anywhere and return a value.

VBA file

Follow these steps

   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

In automation anywhere

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

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Thursday, May 16, 2019

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250