Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi I am trying to create a hyperlink to a file which i can do ok but i need the hyperlink to use the value of a cell as the file name. for example my hyperlink is in cell B1 but and i am setting the hyperlink to a word document in my documents, however i would like the hyperlink to use the value of cell A1 as the file name for the hyperlink when it looks in my documents for the word file. can this be done??

share|improve this question
up vote 2 down vote accepted

Try this formula in the cell where you want the hyperlink.

=HYPERLINK((CONCATENATE("D:\documents and settings\<User>\My Documents\", B1)) // eg: HYPERLINK(B1)
share|improve this answer
Sandeep sorry i dont think u get what i mean i want the hyperlink to use the cell value of A1 as the file name when it is opening from my documents – Roger Mar 26 '12 at 6:44
@Roger : How about the edited formula above?? The column B1 should have the filename (which is present in My documents folder) – Sandeep Mar 26 '12 at 6:49
Sandeep i used the edited formula with my path as shown =HYPERLINK((CONCATENATE("\Red_server\Documents\aaa\aaa CONTROLLED DOCS\INDIVIDUAL RECORD SHEETS\",A1562))) the ending was a requested modification by excel but this wont work. Any suggestions??? – Roger Mar 26 '12 at 7:25
I got it Sandeep thanks for your help it is much appreciated – Roger Mar 26 '12 at 7:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .