Call vb script

It shows the operations to be performed automatically with the help of “Vb script” in a way to be integrated with a workflow application.


* Script	The vb script code is written in this field.
Result variable	Result variable name.

Note: * Fields selected with are required, others are optional.

Script example

You can use the Script as shown in the example (Hidden sheet in an excel file).

Set objXLApp = CreateObject("Excel.Application")
objXLApp.Visible = false
Set objXLWb = objXLApp.Workbooks.Open("C:Robusta_Projectxxxxyz.xlsx")
Set oSheet = objXLWb.Worksheets("Summary") 
oSheet.Visible = xlSheetHidden            
objXLWb.save
objXLWb.close false
objXLApp.Quit
Set objXLWb = nothing
Set objXLApp = nothing

Note

If windows script version message is not wanted to appear in the result variable,

cscript //NoLogo

command should be added to the first line.