| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hyperlink Locates file regardless of it's location
Hi,
I have a 100's of hyperlinks that take a part number from a cell and then point to and open a corresponding pdf drawing located in z:\\server-h\vol1\data\xx.pdf However some of the pdf files are located in '...vol2\data\xx' Can the hyperlink not have a formula or some msdos command in it so that it can search for a particular filename by itself on the whole hard drive. This way if the pdf files get moved around there will be no problem with the hyperlinks? I'm using Excel XP 2002. Thanks, Avais |
|
#2
|
|||
|
|||
|
AC wrote...
I have a 100's of hyperlinks that take a part number from a cell and then point to and open a corresponding pdf drawing located in z:\\server-h\vol1\data\xx.pdf However some of the pdf files are located in '...vol2\data\xx' Can the hyperlink not have a formula or some msdos command in it so that it can search for a particular filename by itself on the whole hard drive. This way if the pdf files get moved around there will be no problem with the hyperlinks? I'm using Excel XP 2002. No. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
| hyperlink an excel cell to a specific location wthin application f | Excel Discussion (Misc queries) | |||
| Add a default location for print to file in Excel. | Excel Discussion (Misc queries) | |||
| location of backup file | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
