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

Can anybody post some real time scenario in qtp? please its very urgent.

0 Answers   Kanbay,


why is execute file used.

1 Answers   Deloitte,


How can we change(increase or decrease)the size of a array variable with out loosing the previous values

1 Answers   DST Global Solutions,


write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..

0 Answers  


How many ways we can parameterize data in quicktest professional (qtp)?

0 Answers  


i need the word "good morning" to be displayed by default whenver we click upon the blank test while opening the qtp. Could you please answer...

7 Answers  


Why we have to split actions in a test?

4 Answers  


What r the advantages of automation?

3 Answers  


How can we get a textcheckpoint in QTP9.1?

2 Answers   EmTechPro,


Hi friends, I have heard that it is required to have an application hosted in the same machine where we use QTP. Otherwise QTP may identify the objects incorrectly. Please clear me is it true.

3 Answers  


How do you synchronization point through DP?

0 Answers  


how qtp will recognise if application is run on many browsers

1 Answers   Cap Gemini,


Categories