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 |
Can anybody post some real time scenario in qtp? please its very urgent.
why is execute file used.
How can we change(increase or decrease)the size of a array variable with out loosing the previous values
1 Answers DST Global Solutions,
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
How many ways we can parameterize data in quicktest professional (qtp)?
i need the word "good morning" to be displayed by default whenver we click upon the blank test while opening the qtp. Could you please answer...
Why we have to split actions in a test?
What r the advantages of automation?
How can we get a textcheckpoint in QTP9.1?
Hi friends, I have heard that it is required to have an application hosted in the same machine where we use QTP. Otherwise QTP may identify the objects incorrectly. Please clear me is it true.
How do you synchronization point through DP?
how qtp will recognise if application is run on many browsers