multiple hyperlinks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KK - 15 Jul 2007 12:47 GMT

Hello,

I have Excel 2007 running under Vista

I have a spreadsheet which lists in a column all the files in a certain
folder. I am trying to create a hyperlink between the spreadsheet entries
and the files themselves.

I know how to do this using the 'hyperlink' option, or Ctrl-K, but it is a
very slow process as I have to link files one by one.

Is there a way of linking several files simultaneously ? (I have tried
selecting a group of cells but they all link to the same file)

Thanks for all advice

KK

Reply to this Message

Dave Peterson - 15 Jul 2007 13:00 GMT

Maybe you can use the =hyperlink() worksheet function.

In an adjacent cell and depending on what you have in your cells:

=hyperlink("file:////" & a1,"Click me")
or
=hyperlink("file:////c:\my documents\excel\" & a1,"Click me").
or
=hyperlink("file:////" & $x$1 & a1,"Click me")

if x1 contained the folder name

> Hello,
>
[quoted text clipped - 13 lines]
>
> KK

Signature

Dave Peterson

Reply to this Message