how to compare two excell sheets by using vbscript??
Answer Posted / deven
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open("E:\Deven1.xls")
Set objWorkbook2= objExcel.Workbooks.Open("E:\Deven2.xls")
Set objWorksheet1= objWorkbook1.Worksheets(1)
Set objWorksheet2= objWorkbook2.Worksheets(1)
For Each cell In objWorksheet1.UsedRange
If cell.Value <> objWorksheet2.Range(cell.Address).Value
Then
msgbox "value is different"
Else
msgbox "value is same"
End If
Next
objWorkbook1.close
objWorkbook2.close
objExcel.quit
set objExcel=nothing
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Does QTP record on Objects created on XWindows Environment?
How to test background color and dynamic images during run time can you put the check point for moving objects?
Hello everyone! I am just writing a small test for a windows application. I have a problem with a text output value. The value i am trying to catch is presented in a scrollable textbox. When the text is too long, only a portion of it gets captured. Do you have any experience with this?
What are the types of data tables in qtp?
What is standalone database?
Connect to QC using AOM.
how interviews will be on QTP?
What is the file extension of the code file and object repository file in QTP?
How can you close the second opened browser?
What are the 3 main stages involved in testing with qtp?
Your roles and responsibilities and daily tasks? (As automation tester)
How to break the object spy ?
How is UFT 11.5 version different from UFT 12.0?
what is vmodel?advantages and disadvantages of vmodel?
what are the mandatory properties for a tex boxc (scenario?)