Man illustrationFlower illustration


Call vb script

Estimated reading: 1 minute 72 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 variableResult 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_Project\xxx\xyz.xlsx")
Set oSheet = objXLWb.Worksheets("Summary") 
oSheet.Visible = xlSheetHidden
objXLWb.close false
Set objXLWb = nothing
Set objXLApp = nothing