VBScript Tutorial for Beginners, VBScript Environment, VBScript Language fundamentals, VBScript control flow, and VBScript object models. Introduction: • Visual Basic Scripting Edition is a lightweight language from Microsoft. • VBScript derived from VB Programming language. • VBScript is not a case-sensitive language. • VBScript is a lightweight language and it has fewer formalities for writing … Read more
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