Answer / kishore

Getting User id from Excel 1

Set objxls = createobject("Excel.Application")
objxls.workbooks.open "C:\Documents and
Settings\ranantatmula\Desktop\data.xlsx"//path of the excel
sheet where user id is stored
v1 = objxls.cells(1,1) // where user id is stored in Excel
browser("xxx").page("yyy").webedit("username").set(v1)

Get PWD from excel 2
Set objxls1 = createobject("Excel.Application")
objxls.workbooks.open "C:\Documents and
Settings\ranantatmula\Desktop\data1.xlsx" //path of excel
where pwd is stored
v2 = objxls.cells(1,1) // where PWD id is stored in Excel
browser("xxx").page("yyy").webedit("username").set(v2)


To export the result in Excel 3

Set objxls3 = createobject("Excel.Application")
set objworkbook = objxls3.workbooks.Add


write a condition if page is opened

browser("xx").page("xx").webedit("userid").click
browser("xx").page("xx").webedit("pwd").click
browser("xx").page("xx").webbutton("submit").clcik


If page opens

objxls3.sheet(1).cells(1,1) = "PASS"

else

objxls3.sheet(1).cells(1,1) = "FAIL"

Endif

in qtp how we work with out put values and what is the process?

4 Answers  

---

How to create Reusable and Multiple Actions?

0 Answers  

---

During test run,How will you copy/paste from/to clipboard?

3 Answers  

---

Which functionalities of QTP used in banking project? pls any say answer?

0 Answers  

---

how to make connection to a remote mysql database in qtp any one can please provid eme deatail steps.

1 Answers  

---

How will u declare a variable to access multiple actions? a)Dim b)Global c)Public d)Private

1 Answers  

---

I encountered with very strange problem in qtp while writing the script i written the code window"regexpwndclass:=XLMAIN").window"regexpwndtitle:=Open" ).Exit this code was working fine for about 10-15 times i executed the script but after some time qtp started giving the error with the same code the error is "Object doesnt support this method or function window(...).window(..)" then i modified the code with only window"regexpwndtitle:=Open").Exit in place of window"regexpwndclass:=XLMAIN").window"regexpwndtitle:=Open" ).Exit now again its working fine i cannot understand what thing is creating the problem if same code executed successfully in starting for about 10 times then why it is giving the error now can anyone give the reason .

0 Answers  

---

What is Tree view?

2 Answers  

---

What is the difference between functional spec. and Business requirement specification?

5 Answers  

---

How is GC reddy online program Will i get placed How are the placements.

1 Answers  

---

How to get Traceability matrix from TD?

0 Answers  

---

Dis advantages of XML checkpoint ?

0 Answers   Sapient,

---