Interested to Buy Any Domain ? << Click Here >> for more details...
How to Compare the 2 xl-sheets in QTP? ple write the vb
Script for the comparison?
- 1 Answers
- 6594 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 |
Give me diffrent script in QTP for Webpage(Java and .Net),WindowsBased Applications,Java application,.Net application...
How to Analyze the Checpoint results by Text/Text Area Checkpoint?
How to resume the second iteration in the QTP,, if the error has intrupted the the second iteration. When i use run from step it starting from the first iteration again.
What is checkpoints for quicktest professional (qtp)?
How many types of parameters are available in quicktest professional (qtp)?
what is the hierarchy to use properties in descriptive programming
Hi any body can tell me the synchranization point syntax thanks in advance
Can we add the objects of an application dynamically?
2 Answers KEN Group, LD College,
Tell me Three major differences between QTP & Winrunner?
Please explain how to open with notepad of saved html file by right click option using QTP
How to see the screens after running test in QTP?
What are the different types of recovery operation?
WinRunner 
