Man illustrationFlower illustration

Call vb script

Estimated reading: 1 minute 275 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.

*ScriptThe vb script code is written in this field.
Result variable nameResult 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.close false
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.

Share this Doc

Call vb script

Or copy link

Chat Icon Close Icon