dynamic link two office files

J

Jerry McCormack

I have a large data base which include of Office files. I want to create a
ExCEL file that will link to these files by clicking on a hyperlink. This
will work as long as the directory structure does change. How can dynamical
link these file so I can change the file location/storage (all file in same
location)?
 
M

mezzodiva

You don't mention what version of Excel / Office you are using, but if you
search for the words

relative hyperlink

in Excel, you should get the information you want to know.
 
Top