hyperlink to files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have about 1000 excel files and i need to put a hyper link in each of them
to a differnt file on a network drive, the file name is the same as one of
the cells on worksheet.

Is there a way to include the text in the cell as part of the hyperlink text?

Andy
 
If A1 is your hyperlink and B1 contains the filename, cant you just use
=HYPERLINK(B1,B1)

Note, the first B1 reference is the actual 'url', the second B1 reference is
its 'friendly' name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can UDF return a customized hyperlink? 3
HYPERLINK using a date in a cell 2
HYPERLINK Worksheet Function 3
Hyperlink from one.xlsx cell to another two.xlxs cell & click back 1
Hyperlink Formula Problem 2
2002 Hyperlink issues 2
How to create a hyperlink to open a file with part of the name 4
Hyperlink to named range in workbook 1

Back
Top