Tagged: VBScript Tutorial for beginners

VBScript Excel Object Model

VBScript Excel Object Model

VBScript Excel Object Model It is used to Perform Operations on Excel Application. Excel Application Excel File / Excel Workbook Excel Sheet / Excel Worksheet Create Excel Application Object Syntax: Set variable = CreateObject(“Class...

VBScript FileSystemObject Part-2

VBScript FileSystemObject Part-2

VBScript FileSystemObject Part-2 1) Write data Continuously in a Text file. Dim objFso, objTextstream, num1, num2, Res num1=10 : num2 =20: Res=num1 + num2 Res2=num1*num2 Set objFso = CreateObject(“Scripting.FileSystemObject”) Set objTextstream = objFso.OpenTextFile(“C:\Users\G C...

VBScript Tutorial 10

VBScript Tutorial 10

VBScript Tutorial 10 (Error Handling, Debugging Scripts) Error Handling using VBScript: Handling expected and unexpected Errors > Expected Errors: Whenever we use Invalid input then we can expect Errors. Note: We use Invalid input...

VBScript Tutorial 8

VBScript Tutorial 8

VBScript Tutorial 8 (Excel Object Model in VBScript) Excel Application operations using Excel Application Object Excel Application Object: It is used to perform operations on Excel Application. Create Excel Application Object: Set Variable =...

VBScript Tutorial 7

VBScript Tutorial 7

VBScript Tutorial 7 (VBScript File System Operations Part-2) 6) Create a Text file Note: File System Object is only used for Drives, Folders and Flat files. We can create and delete other types of...

VBScript Tutorial 3:

VBScript Tutorial 3:

VBScript Tutorial 3: (VBScript Variables Part-2, Constants, VBScript Operators, Conditional Statements Part-1) iii) Variables 1) What is Variable? 2) Declaration of variables 3) Implicit and Explicit variables. 4) Assigning Values to Variables 5) Purpose...

VBScript Tutorial 1

VBScript Tutorial 1

VBScript Tutorial for UFT I) Introducing VBScript: > Visual Basic Scripting Edition, It is a light weight language from Microsoft. > VBScript derived from VB Programming language. > VBScript is not a case sensitive...