Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
hyperlink to jpg files | Excel Discussion (Misc queries) |