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