How would one set up relative hyperlinks in Excel? For example, if the links
refer to a file system directory, so that the whole hyperlink would be <base
directory>/<variable part of filename>, how could one set things up so that
if the <base directory> were to change, one could either change one value or
change all of the hyperlinks at one shot?

Let's say that <base directory> = "c:\my files\html base\" and <variable
....> = "html_file1.htm", "html_file2.htm", etc. How would I change the
"c:\my files\html base\" to "c:\my files\other html base\" with one edit?
And how do I set up relative hyperlinks in the spreadsheet?

I have very minimal Excel knowledge/experience. So please keep things real
simple for me, if possible.
--

Chaim