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

How can we use the "CreateObject("Shell.Application")" in QTP and what is the definition and purpose of it?

0 Answers  

how to recall a function in QTP?

3 Answers   Ordain Solutions,

What is the present version of the VB Script we are using

1 Answers  

how to write regular expression for Date field?

12 Answers   Google,

hi i have one issue while automating the script using QTP i want scrool down .i cannot do even using scrool down methqad is not working .the object will take WebElement plz is there any code help me

3 Answers  

Which object repository we use in real time and can we merge 2 object repostiory and how?

3 Answers  

Please give me the steps to carry out datadriven in QTP8.2

2 Answers  

how to get column count in datatable

3 Answers  

What is meant by Environmental variables?2 types r there know…can u pls explain clearly?

1 Answers  

key word driven frame work is like a folder structure Question is that where is the folder like funtion library folder,object repository,data base,application scenerio folder etc are store whether in a remote machine where we have to access or in our machine (it just like VSS)

0 Answers   Kanbay,

New to QTP: In a qtp flight booking application, I tried to parameterize the to and from drop down lists using data table, depending on ur drop down selection it will pop up a list of flights. Here I am not finding a way to select flight randomly from given list... Thanks in advance guys.

1 Answers  

What is the pros and cons between QTP and Rational Robot

0 Answers   Virtusa,