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

Can anyone pls tell me in realtime (descriptive programming) how will the properties of the object be given to the test team. R they given in an excel sheet and is the same sheet also given to the development team and by whom is this given? Thanks a lot.

2045

---

How to carry out bit map check points in QTP

2197

---

Explain how you can delete excel file in qtp?

1050

---

Explain building blocks of the bpt framework ?

1124

---

How often were they executed?

2458

---

Both static and dynamic arrays are handled by the vb script. Is it true?

1041

---

Which recording modes need more memory?

1065

---

What are test settings and global settings?

1098

---

What is quicktest professional (qtp)?

1045

---

what are the limitations of smart identification in qtp 9.0

2377

---

what r the main attributes of test automation?

2080

---

In qtp, how you can remove the spaces from string?

997

---

how can i pass a "cript"as a parameter in to a function

1995

---

what r the verstions from 1st to present (verstions) of mercury tools (like winrunner,QTP,Loadrunner) ? Chandana

1943

---

describe some problems that u had with automating testing tool?

1800

---