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.