VBScript Tutorial

VBScript Fundamentals & Features Comments To make the code readable To make the code disable from execution Data Types Implicit Declaration of Data Types Only data type is Variant, VBScript condiders data sub types based on usage of data. Check Data sub types using VarType Function Data conversion using Conversion functions Variables a Scalar Variables b Array Variables Dictionary object is equivalent to Associated Arrays / Hash variables in Perl Script Constants Built-in constants User defined Constants Operators Arithmetic Comparison Logical Concatenation operators Conditional statements 1 If statement 2 Select Case Usage of Conditional statements in UFT Test Automation 1 To insert verification points 2 For Error handling Loop Statements 1 For...Next 2 While...Wend 3 Do While / Until...Loop 4 For Each...Next Functions What is a Function? It is a Reusable code Built-in Functions Array Functions, String Functions, Date & Time Functions, Conversion Functions, I/O Functions, Math Functions and Miscellaneous Functions User defined functions Sub Procedures Public Internal, External Function, Private Function Procedures Public Internal, External Function, Private Coding conventions Writing comments Declarations Dim city, num, x With coding standards Dim strcity, intnum, objx Regular Expressions It is a formula for matching patterns Usage of Regular Expressions in UFT a To handle dynamic objects b For search operations Regular expression Object File System Operations What is Computer File System? Examples for File System Operations Create a folder Copy a folder Delete a folder Create a text file write data Read data Compare data Search for data Delete a text file etc... How end user performs File System Operations How to perform automatic File System Operations using VBScript Using File System Object Object Property Method / Operation Create Automation Object Syntax: Set Variable = CreateObject "ClassValue" Set - VBScript statemet CreateObject - Built-in Function Class value for creating File System Object "Scripting.FileSystemObject" Excel Application Object Excel Application Excel File / Excel Work Book Excel Sheet / Excel Work sheet It is used to automate Excel Application Operations Create Excel Take Row Count Take Column count Read data Write data Compare data etc... Class value for creating Excel Application Object "Excel.Application" Word Application Object It is used to automate Word Application Operations Class value for creating Word Application Object "Word.Application" Database Operations a Database Connection Object It is used to connect to Databases Class value for creating Database Connection Object "Adodb.Connection" b Database Recordset object It is used to perform operations on Database Tables /Records Class value for creating Database Recordset Object "adodb.Recordset" Dictionary object It is used to define Key, value pairs Class value for creating Dictionary object "Scripting.Dictionary" Error Handling Handling expected and unexpected errors Using Conditional statements and Exist property Using some Built-in Functions Using Option Explicit statement Using Exit Statement Using On Error Resume Next statement