Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



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

Post New Answer

More QTP Interview Questions

what is exit and entry criteria of automation testing. any body wants a real time script,please mail to me. contactno;9986435766

2 Answers  


Through array we can execute the testcase how ? give me example

0 Answers   TCS,


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.

3 Answers  


How to export quicktest professional results to an .xls file?

0 Answers  


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

2 Answers   PSI Data Systems,


how open two urls in one browser? plz urgent

9 Answers   Satyam,


Explain about invoking of application?

2 Answers  


what is L-trim function will do?

2 Answers  


how to count spaces in a given string ex: "this is jagadeesh" in QTP with simple functional script

5 Answers   Cap Gemini,


Hi All, How to get repeated word in string . Thanks Balaji

0 Answers  


what are the areas that cannot be tested using an automated tool? list a few

3 Answers  


how to test one edit box using Java addin for Web Applications? write script?

1 Answers   IBM,


Categories