Launch multiple links via Excel by exec QTP

[wbsn2000@yahoo.com]

Hi All,

I am new to this forum and so far I enjoy it.
Thanks for sharing all great info in this forum.

I have a question and struggling with a scenario that need your help.
I have an Excel spreadsheet with multiple links in multiple rows.
I want to launch those link by using QTP to open link in a browser, copy the data and write it back to excel spreadsheet.

Setup Excel spreadsheet:
CAR Price
1 link#1 $1.00
2 link#2 $0.00
3 link#3 $10.00
4 link#4 $2.00

Steps:
1) Open QTP
2) Run QTP script
3) QTP_Script open Excel spreadsheet locate in C:/Temp/Test.xls
4) QTP_Script locate a hyperlink in row1/col1 and mouse_click
5) A browser should open and display data table
6) QTP_Script locate a value from data table
7) Copy value
8) Paste the value to excel spreadsheet row1/col2
9) QTP_Script continue run till the last row in excel spreadsheet.
10) QTP_Script stop and exit.

Hope y'all can help me with this case on how to record or write a vbscript.

Thanks for your helps.

[basanth27]

Are you expecting a complete code to perform the above operation ?? if so, i guess it wouldnt be worth anyone's effort other than yours to get it.
Have you tried automating the above scenario so far ?? If yes, would you paste the code and let us know the exact area where you get a error ?

[knowsantu]

This can be performed by reading the value (innertext) from application & update the excl sheet. Can anyone provide the Code please. It would be really helpful.