Answer Posted / lakshmi

Set ObjExcel=CreateObject("Excel.Application")
ObjExcel.Workbooks.Open("C:\Find.xls")
Set Obj=ObjExcel.Sheets.Item(1)
rowcount=Obj.usedrange.rows.count
colcount=Obj.usedrange.columns.count
For i=1 to rowcount
For j=1 to colcount
Aval=Obj.Cells(i,j)
If StrComp(Aval,"HYDERABAD")=0 then
MsgBox "Location Is : ("&i&","&j&")"
Exit For
Exit For
End If
Next
Next

Please let me know if you have simplest answer than this.

Thx

Suppose I have three hyperlinks with same properties. How to solve this and what are the ways to solve this. we can solve this by using index property but what are the other ways we have have to solve this problem. Login (href: btnlogin.aspx) Login (href: Sourcelogin.aspx) Login (href: homelogin.aspx)

1972

---

What is checkpoints for quicktest professional?

995

---

What are the advantages of qtp?

1006

---

can any one say that where we can download the QTP trail version ??????????

1758

---

Generic function to search for the unique link in webtable and click on it

3060

---

Can anyone help.i need total excelsheet operations,shortcuts in testing environment from starting onwards....

2013

---

hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.

1857

---

i'm testing the webpage with QTP, in this wabpage i have to choose the CV from the window, but QTP can't recognize the object, so i used the Low LEvel Recording, but every time i run the test, QTP go to halt when it gets to the Recorded part, any solution for that?( except puting delay in the script and manuall selecting, because i've did that)

2012

---

explain keyword driven framework with banking domain?

2012

---

How can i get the image text that changes dynamically? Here i have used "GetROProperty", but it's not working. I used like Ex:Browser("webmail").Page("inbox").image ("captchaimage).getroproperty("innertext/text/value")

1847

---

I want to capture data(using keyword) from msdos application using QTP?... Below is little work i could do on it... /* Set app=CreateObject("Wscript.shell") SystemUtil.run ("C:\Users\Agent\Desktop\pumpsim\PUMPSIM.EXE") Window(“PUMPSIM.EXE”).Activate wait(3) app.sendkeys "N" */ Thanks in advance...!!!

1859

---

can u explain relative path architecture framework in qtp?

2009

---

What are the major/ important methods, functions in QTP we use realtime testing

2787

---

tell me exact differenceb bw qtp and selenium?(could not tell open soure and licennce? difference in usage and technical difference?

2153

---

after click on compose mail how can we attached a file in qtp with vbscript code

2174

---