Help with Hyperlinks

[david from hawaii]

Hi I am trying to link to external files through hyperlinking, but I don't want to browse for each link. Instead I want the hyperlink to read the file data from a cell and use that as the filename. Is this possible? I haven't found a way to get into the formula of the hyperlinks.

Thanks!
David

 

[Brian from Maui]

Aloha Cuz',

Try this link, lots of hyperlinking answers. Not clear on what you mean by external links.

http://www.mrexcel.com/board/search.php

 

[PaddyD]

Brian,

As yet, the page address of a search doesn't capture the search terms etc, only the blank search page

David,

You can construct working hyperlinks from cell values. If, e.g., A2 held a file name (c:temp.test.xls for example), and B2 a cell refeence that included a sheet name (sheet1!a1), then:

=HYPERLINK("["&A2&"]"&B2,"test")

will work as expected.

Paddy

 

[david from hawaii]

Brian, PaddyD,

Mahalo for your assistance. It worked perfectly! I tried searching the board earlier and it was sloooow, so I decided to just ask. Thanks again.

David

 

[Brian from Maui]

On 2002-09-24 19:35, PaddyD wrote:
Brian,

As yet, the page address of a search doesn't capture the search terms etc, only the blank search page

Paddy,

Why does it do that? I'll remember not to do it again!