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

how interviews will be on QTP?

0 Answers   Fidelity,


What is the ur roles and responsibilities as automation testing engineer?

2 Answers   Atos Origin,


Hi all, In Every interview interview asking one question what type of challenges you have been faced in your project?

1 Answers  


what is life cycle of automation testing ?

7 Answers   HealthAsyst,


hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.

0 Answers  


Suppose i have some records in database now i want to use first 1000 records for one test and next 1000 to 2000 records for another test how can we do this just for ex oracle database pls tell me

1 Answers  


How we can test a Frame in a web page?

1 Answers   eMids,


difference Between Call Run action and copy of action?

3 Answers   Quest,


in a web page How to check and display a particular word from a paragraph?

0 Answers  


What are the views available in quicktest professional (qtp)?

0 Answers  


Can I do Game testing with QTP tool

1 Answers   Google,


GET WHETHER THE GIVE NUMBER VALID OR NOT IN BETWEEN THE GIVEN RANGE?IN VB SCRIPT(QTP)

2 Answers   CSC,


Categories