Execute VB Script

Description

Execute VB Script runs a VBScript within a workflow to automate Windows-based tasks or interact with COM objects and legacy systems. Use this step when your automation involves Windows scripting scenarios that are best handled by VBScript — for example, manipulating Office applications, accessing WMI, or running legacy automation scripts. The script can generate output fields through the standard output stream, making results available as data for subsequent workflow steps.

Configurations

Field Name	Description
Step name	Specify the name of the step; This name has to be unique in a single workflow
Left Panel:
Get Input Fields	Click and select input fields from the list that can be used as a part of VB Script.
Write to Console
Create StdOut Object	Click to create one new stdout object for VB Script. Syntax to create StdOut: objStdOut.WriteLine "<<>>FieldName::FieldValue<<>> Note: To use this option, the system must have wscript.exe installed, and its path must be added in the system’s PATH environment variable.
Write Value to Console	Click to write output field and output value to console which can be used in subsequent steps. Syntax to write value: objStdOut.WriteLine "<<>>FieldName::FieldValue<<>>"
Right Panel:
VB Script	Console to write StdOut and value in VB Script.
Fields Tabel	The Fields table displays a list of output fields extracted from script. It also allows users to add metadata such as descriptive names for each field.
Field Name	Displays name of the fields extracted from the script. for example, from ConsoleWrite("<<>>FieldName::FieldValue<<>>")
Rename to	Optional new name for the field. Used when you want to display or reference the field using a different name.
Type	Select the data type of the field. Following are the type and available supported formats: Supported types are: - String - Date: Supported formats: - yyyy-MM-dd - dd/MM/yyyy - MM/dd/yyyy - dd-MMM-yyyy - yyyyMMdd - dd-MM-yyyy - yyyy/MM/dd - dd.MM.yyyy - MMM dd, yyyy - dd MMM yyyy - Boolean - Integer - BigNumber - Binary - Timestamp: Supported formats: - yyyy-MM-dd HH:mm:ss - yyyy-MM-dd’T’HH:mm:ss - yyyy-MM-dd’T’HH:mm:ss.SSSX - MM/dd/yyyy HH:mm:ss - dd-MMM-yyyy HH:mm:ss - Internet Address
Length	Specifies the length of the field: - Number: Total number of significant digits - String: Maximum number of characters - Date: Length of the printed date output
Precision	Specify the number of digits to display after the decimal point. This applies only to numeric types. - Number: Defines floating-point precision. - Other types: This setting is not used.
Replace value ‘Fieldname’ or ‘Rename to’	Select Y (Yes) to find an existing field in the input stream that matches Fieldname and replaces its value. Select N (No) to add a new field to the output stream.
Action Button
Get Output Fields	Click Get Output Fields to see all output field details in table. When the Get Output Fields is clicked, the tool scans the entire script and looks for statements in the following format: objStdOut.WriteLine "<<>>FieldName::FieldValue<<>>" It parses these statements, extracts the FieldName, and populates the Fields table accordingly.