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...

  1. Categories >> Software >> Testing >> Automation Testing >> QTP
  2. Suggest New Category

How to Compare the 2 xl-sheets in QTP? ple write the vb
Script for the comparison?

Question Posted / venkat.thota


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 are the views available in qtp?

0 Answers  

Does QTP work in UNIX environment

5 Answers   BirlaSoft, C1 India,

can i automate java web application using qtp web addin only not using java addin

1 Answers   Infosys,

How can we open an Excel sheet through the script

8 Answers   eSymbiosis,

1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?

0 Answers  

What is difference between shared and local object repository?

0 Answers  

.how will you load the object during runtime

2 Answers   TCS,

What is meant by Step generator?what is the use of this? we have 3 steps know there what r all those.? can u all pls give me clear idea of this

0 Answers  

Hai anyone please "Explain about Framework in QTP?"

0 Answers  

Without QTP (or any Testing tool) can we able to test the GUI part of the Applications. for Example generating the Scripts in Notepad and Executing them Using VB. Is it Possible to do so.. Correct me if iam wrong some where.

8 Answers   Microsoft,

How to Test Dynamic links ?

4 Answers   Wipro,

I have a web table,in that web table in 3rd row 4th coloumn i have a link how to click it with descriptive programming? I have a webedit without entering any value how to calculate the size of that field? I have a DB table , how to find the 5th highest salary? write query.

2 Answers   3i Infotech,

For more QTP Interview Questions Click Here
Categories