hyperlink to files
 

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

hyperlink to files
 

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.

"Andy" wrote:

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