Help with Hyperlinks

david from hawaii

New Member
Joined
Sep 23, 2002
Messages
2
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
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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
 
Upvote 0
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
 
Upvote 0
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! :oops:
 
Upvote 0

Forum statistics

Threads
1,206,949
Messages
6,075,811
Members
446,158
Latest member
octagonalowl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top