multiple hyperlinks

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

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
 
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
 
Back
Top