How to Compare the 2 xl-sheets in QTP? ple write the vb
Script for the comparison?
- 1 Answers
- 6030 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can anyone tell me how i used QTP 9.2 use for GIS based S/w with an example?
Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln
regular expression in qtp standar check point for months from accepting months from january to december only
Tell me about qtp?
What are the benefits of qtp?
hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]
assume i have few url link how will i dynamically call then using descriptive programming?
What are table and db checkpoints?
Have you done batch testing in qtp? If yes how you are doing?
Explain process of smart Identification in QTP?
iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?
Explain about Test Fusion Report of QTP?
How to use output values in qtp ?
How to associate shared object repository to test in qtp?
What is reusable action?
