How to Compare the 2 xl-sheets in QTP? ple write the vb
Script for the comparison?
- 1 Answers
- 5940 Views
- I also Faced
- E-Mail Answers
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 many wayes we do the parameterization?
What are the views available in qtp?
More details about keyword driven technique in QTP
In Manual testing , can u prpare bug report in TD?
how to record a word doc using qtp i.e open a word doc,type something and save the doc can someone send me the code.
MANUAL TESTING, AUTOMATION TESTING QTP,QC , Load Runner , SELNEIUM ONLINE TRAINING
how to post xml data from QTP scripts to any application?
What are the recording modes in wave event?
Explain the difference between data driven testing and parameterization ?
how to explain a claims and insurance project?
Create an Excel file and pass the values from Flat File? (for ex:data1.txt,data2.txt )
How can we translate the steps between the Keyword and Expert Views?
WinRunner 
