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 |
what is exit and entry criteria of automation testing. any body wants a real time script,please mail to me. contactno;9986435766
Through array we can execute the testcase how ? give me example
In an Excel sheet take two fields as agentname and password and type some valid agentname and password.call that excel sheet in qtp so that qtp opens the flightreservation window taking into consideration how many records are entered in the excel sheet.For example if 3 records are entered today it will open 3 FR windows,if in near future the records are more than 3 then it will open that number of times.
How to export quicktest professional results to an .xls file?
what is qtp automation framework, what is the purpose of the framework and which folders included in this framework pls tell me with brief description
how open two urls in one browser? plz urgent
Explain about invoking of application?
what is L-trim function will do?
how to count spaces in a given string ex: "this is jagadeesh" in QTP with simple functional script
Hi All, How to get repeated word in string . Thanks Balaji
what are the areas that cannot be tested using an automated tool? list a few
how to test one edit box using Java addin for Web Applications? write script?