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,,,

Hi, i am rani ,i am putting 1+years of fake exp ,so pls anyone explain how i get project (in real time) ? how it is tested ex: in banking ,test the number of textboxes in one window

3 Answers  

How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?

0 Answers  

what is defination of system testing?

3 Answers   CodeArrow, Infosys, Omax,

I am using environment variable xml to give credenatials for login into unix. Is there any way we cam mask the password in the xml?

1 Answers  

I am not finding pages and links in object spy on web testing. I am only getting window and winobject. where is the problem? thanks

4 Answers  

what are the challenges do we face while testing webbased applcations using the automation tool QTP or any?

4 Answers   BirlaSoft,

How to measure transaction time through VBScript without using start and end transaction points?

0 Answers  

Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

3 Answers  

What kind of performance is expected on the client side (e.g., how fast should pages appear, how fast should animations, applets, etc. load and run)?

0 Answers  

How do you use the parameters.input parameters and out put parameters.

1 Answers   Polaris,

Which statement will use for close an action in QTP?

0 Answers  

what is the difference between development and testing

1 Answers