How to Compare the 2 xl-sheets in QTP? ple write the vb
Script for the comparison?
Answer / rentalavdml
Set objExcel = CreateObject("EXCEL.APPLICATION")
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open("C:\Documents and
Settings\user\Desktop\sriya1.xls")
Set objWorkbook2= objExcel.Workbooks.Open("C:\Documents and
Settings\user\Desktop\sriya2.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
cell.Interior.ColorIndex = 3
'Highlights in red color if any changes in cells
Else
cell.Interior.ColorIndex = 0
End If
Next
set objExcel=nothing
| Is This Answer Correct ? | 5 Yes | 5 No |
how interviews will be on QTP?
What is the ur roles and responsibilities as automation testing engineer?
Hi all, In Every interview interview asking one question what type of challenges you have been faced in your project?
what is life cycle of automation testing ?
hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.
Suppose i have some records in database now i want to use first 1000 records for one test and next 1000 to 2000 records for another test how can we do this just for ex oracle database pls tell me
How we can test a Frame in a web page?
difference Between Call Run action and copy of action?
in a web page How to check and display a particular word from a paragraph?
What are the views available in quicktest professional (qtp)?
Can I do Game testing with QTP tool
GET WHETHER THE GIVE NUMBER VALID OR NOT IN BETWEEN THE GIVEN RANGE?IN VB SCRIPT(QTP)