If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link to Excel problem | Jeff | General Discussion | 0 | July 21st, 2004 02:00 AM |
Link to Excel from Outlook message | Jeff | General Discussion | 0 | July 18th, 2004 06:37 PM |
Still having Web Page Pathing Problems / Relative Links show Netwo | webmaster | Powerpoint | 27 | July 15th, 2004 11:16 PM |
Too many hyperlinks? | [email protected] | Powerpoint | 7 | May 25th, 2004 02:19 AM |
Stubborn Link Data/Value Problem - Help Appreciated! | Jax | Links and Linking | 5 | January 8th, 2004 07:46 AM |