http link

Hi,

First of all, excuse me for my bad english ... I'm Portuguese :-)

I need to create links from a worksheet to my web shop. I have a column with
the ID numbers (like, A1 = 1066, etc)and i need to have a link like:
http://www.multimediastore.pt/shop/p...oducts_id=1066
Where the ID is the content of the cell.

Can you help me ?

Regards,

Joel

Multimediastore - Info wrote:
I need to create links from a worksheet to my web shop. I have a column with
the ID numbers (like, A1 = 1066, etc)and i need to have a link like:
http://www.multimediastore.pt/shop/p...oducts_id=1066
Where the ID is the content of the cell.


Use the HYPERLINK worksheet function
=HYPERLINK("http://www.multimediastore.pt/shop/product_info.php?products_id="
& A1),"Info on " & A1)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill;


I have a similar problem and would therefore love to hear your take on it.

In my spreadsheet, there are a large number of cells with content like -
=HYPERLINK("http://Johnen.stream.com/mcasx.asx?media=2764375&system=4536760"
)

I am trying to launch audio/video files within Windows Media Player.
Now the file may or may not exist, so I have to find a way to determine/test
whether file exist, even before I attempt to play the audio/video.

Is there an Excel FUNCTION that can be used for this purpose ?



Thanks,
John.



"Bill Manville" wrote in message
...
Multimediastore - Info wrote:
I need to create links from a worksheet to my web shop. I have a column
with
the ID numbers (like, A1 = 1066, etc)and i need to have a link like:
http://www.multimediastore.pt/shop/p...oducts_id=1066
Where the ID is the content of the cell.


Use the HYPERLINK worksheet function

=HYPERLINK("http://www.multimediastore.pt/shop/product_info.php?products_id=
"
& A1),"Info on " & A1)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

JohnNews wrote:
I have to find a way to determine/test
whether file exist, even before I attempt to play the audio/video

Is there an Excel FUNCTION that can be used for this purpose ?


I don't believe so.
For one thing, there is no "file" that you could test for the existence
of.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup