I post a spreadsheet on our server which contains hyperlinks to documents on the server. I have been asked to copy this file and all associated linked files to a CD. Since the CD drive letter can change with machines, how do I write the hyperlinks so they point back to the files? The linked files and the spreadsheet can all be contained within a single parent folder.
Any help or pointers to help are appreciated.
(Note: this was also posted to the Excel.misc newsgroup, but I don't know if my post went through - the network connections are kind of flakey right now.)