Call vb script

Estimated reading: 1 minute 332 views

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 name	Result variable name.

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

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

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

cscript //NoLogo

command should be added to the first line.

Call vb script

Call vb script

CONTENTS