Answer / manju

'path of the excel file is - path
'excel file name is abc.xls - columns flag & urlxl
'sheet name of the xl file where the url's are present
is "list"

datatable.addsheet("Urllist")
datatable.importsheet("path abc.exls","list","Urllist")
count=datatable.getsheet("Urllist").getrowcount
for i = 1 to count
datatable.getsheet("Urllist").setcurrentrow(i)
flg=datatable("Flag","Urllist")
if flg='Y' Then
url=datatable("urlxl","Urllist")
systemutil.run("url")
End if

Answer / murli.me

get data from exel file into two variables for col(A) and
col (B).
get the Flag into a variable
count the no of URL's.
check the condition for the flag if flag=y then repeat the
test for the no of times the URLS are present..


is this right... if not sujjest me the right one please......

Answer / murli

get data from excel
n=datatable.usedrange.rows.count
for i= 0 to n
a(i)=workbook.cells(i,1)
x=a(0)
y=a(1)
next
if x=yes then
write script
endif

Answer / nil

Thanks Manju and Murli,

After doing bit modifications The above code worked fine
for me....

Please check for my new question whenever u get free time.
Regarding
(How to trap an error message on Web page through QTP.)
Thanks a lot for ur great help :).

Answer / nil

Hi,
Thanks for ur answer :)
I'm sure your answer would be correct. but it would be
great if you provide me code, as I'm not that perfect in VB
scripting.


Thanks Again :))

Answer / murli

you can better use recovory scenarios,,,

What is the architecture of framework

0 Answers  

Whether it is possible to test the adobe's controls like zoom, resize, save etc using QTP...If yes, how u can do the same?

1 Answers  

Explain about invoking of application?

2 Answers  

how to test background color and dynamic images during runtime

4 Answers   CTS,

What is throw object?

1 Answers  

How to connect the remote desktop using QTP 9.2 explain the method or procedure?

0 Answers   Magna Infotech, Oracle,

write a script to close all open browser in qtp except one browser whose name is xyz

6 Answers   Cap Gemini,

I need Major Help with a Script I recorded in QTP 9.5. I am recording scripts for a Web-based application(s) I have all the URLs for each application in Excel spreadhsheet so that QTP can pull that particular application from the spreadsheet and run it. The problem is QTP isn't recognizing one particular URL so when I hit run in QTP to run this script it opens the internet Explorer but isn't open the URL I have in the Excel spreadsheet. I've retyped the URL and still QTP won't open this Particular one for some reason. The site its self is working fine but for whatever reason QTP won't open it. How do I resolve this? I have a deadline of next Friday the 7th to complete this task so please help me in any way you can. Thanks in advance

0 Answers  

What does it mean when a check point is in red color? What do you do?

0 Answers  

How to do Laod testing for web based Application?

1 Answers  

How do you send email with attachment from outlook using qtp ?

0 Answers  

what is descriptiveprograming? how to do object identification thrugh Descriptive and is possible smart identification or not

5 Answers   Syntel,