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 for Negative Testing. > Unexpected Errors i) Resource missing ii) Insufficient Resource iii) Resource Response How to Handle Errors: i) Using … Read more

VBScript Tutorial 9

VBScript Tutorial 9 (VBScript Excel Application Operations – 2, Database Operations and Dictionary Object) Excel Data Comparison Examples: 1) Read data from an Excel file and Compare 2 Columns (One to One Binary Comparison). Dim objExcel, objWorkbook, objWorksheet, i, RowsCount Set objExcel = CreateObject(“Excel.Application”) Set objWorkbook = objExcel.Workbooks.Open(“C:\Users\gcreddy\Desktop\abcd.xls”) Set objWorksheet = objWorkbook.Worksheets(1) RowsCount = objWorksheet.UsedRange.Rows.Count … Read more

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 = CreateObject(“Excel.Application”) ———————- Excel Application Excel Workbook / File Excel Worksheet / Sheet Excel File Operations using VBScript Examples: 1) Create an … Read more