Answer Posted / raju

Set xl = CreateObject("Excel.Application")
set xlwbook = xl.Workbooks.Open(Excel Path)

Set xlWS = xlwbook.Worksheets(1)

Set k = xl.Worksheets(1).UsedRange.Find(Value to
Search)
On error resume next
k=k.value
If err.number>0 Then
msgbox "Pass"
else
Flag=0
If flag=0 Then
Status = "Pass"
StepDesc = "The Work Book has the
values "
Else
Status = "Pass"
StepDesc = "The Work Book Does not
has the values "
End If
End If

Set xlWS = Nothing
set xlwbook = Nothing
Set xl = Nothing

Please let me know if it's not working
raju.ippali@gmail.com

How to release all resources file from the QTP?

1495

---

What are the different kinds of test steps?

1017

---

What is data driver in qtp? Where we use it?

963

---

what are the critical test cases in crm? tell me atleast 5 critical test cases? what are the critical bug u find out while testing crm domain?

3139

---

What is the Difference between test object and run time object?

1117

---

Can we run test with out adding object in object repository? How it is possible?

1016

---

how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?

2359

---

An action has both shared and local OR associated with it and both have the same object in them. In the test which one will be considered?

955

---

How the exception handling can be done using quicktest professional (qtp)?

1016

---

I want to write some certification courses, so friends could you guide me? which certification is best and how to write exam and what tutorials need to be studied,what to do first, I am working on automation tool QTP 9.2

1935

---

Hi All, issue is related to handling pop up script generated in IE, and run on mozilla. In App Under Test, when we get the alert pop ups, we just click ok button. if we need to run the same code on mozilla it will not identify . so we will check browser if browser(*).dialog(IE object).exits browser(*).dialog(IE object).winbutton(OK).click else 'by default mozilla browser(*).dialog(mozilla object).page(*).webbutton(OK).CLICK END IF But my qustion is. Do we write the above piece of code where ever we get such kind of pop ups from the application like alert pop up, confirmation pop up.... OR do we have any other alternative way to do this by using any functions in Recovery Scebarios? If Any of u know idea please do help me in this regard. or send answer to kravimb@gmail.com

1872

---

What is the keyword view and expert view in qtp?

893

---

Difference between copy to action and call to action?

966

---

How can i use virtual objects? If have i created one new virtual object in a virtual object manager by following instructions.

1870

---

what are the limitations of smart identification in qtp 9.0

2313

---