Man illustrationFlower illustration

Docy

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.save
objXLWb.close false
objXLApp.Quit
Set objXLWb = nothing
Set objXLApp = nothing
CONTENTS