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

Advertise your Business Here

Refer this Site

Login | Sign Up


	SiteMap shows list of All Categories in this site.

Categories >> Software >> Testing >> Automation Testing >> QTP

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test Interview Questions

Automation Testing AllOther Interview Questions

Question

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

Question Submitted By :: Venkat.thota

I also faced this Question!!

Rank

Answer Posted By

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

Answer
# 1

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 ?

2 Yes

5 No

Rentalavdml

Question	Asked @	Answers
Other QTP Interview Questions


Have you performed Debugging and how did you?		2
how qtp identify two objects having same name, supose objects are in same page also with same name,specify spl feature.	IGT	4
What is Data driven Testing Frame work.Anybody can expain it in Detail.. Pls anybody can give the answer.. Thanks in advance...	Navis	1
how you update scripts in qtp?		1
Is it mandatory to know abt regular expression in descriptive programming		2
What criteria do you use when determining when to automate a test or leave it manual?		2
Test Life cycle starts IS it Requirments stage or Test Initiation?		1
how we connect oracle or sql data server database to qtp.	TCS	3
hi This is Harish.1. What is object repositery .2. what is frame works in QTP,what is keyword driven frame work,explain it and how to associate the folders.3.the build is developed in java, can we write scripting in vb .4.what is discriptive progaram,how to write it.5.what is process of QTp testing.6. how to associate the shared repository. 7.what is implicit and explicit 8.what is runtime data please replay me regards Harish	Syntel	3
WHO TAKE DECISION TO RELEASE THE BUILD	IGT	1
in QTP we test web based application at that time what script is run? is support vb script? plz tell me		3
what is the main use of reviews	Ordain-Solutions	1
How can I generate customized logs in QTP ?	Ordain-Solutions	1
what is reusable action and how the same can be implemented (process)?		2
what r the 3 basic factor on which we determine to perform automation	AppLabs	5
How to export QTP results to an ".xls" file?		3
Which Databases supports for QTP?		2
i have a window , initial its name is "NEW CUSTOMER" i have to enter the details of customer in the test object fields and after saving the window name is automatically changing with the customer name . so how to identify that window after saving. (i am using descriptive programming.)	Syntel	3
What are the Automation Limitations??		1
How can we test an XML using QTP? I have been to an interview, where they have given me an XML which had 15 values and they have given those values on a separate page. They asked me to write a QTP script to check the XML is having those particular 15 values.		2

For more QTP Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com