Hyperlinks in file on CD?

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.)

Ed

Thank you! I set the hyperlinks as \\foldernam\docname.doc, and placed the folder with the linked docs inside the parent folder containing my spreadsheet. After I burned the CD, I gave it to a co-worker and it worked great!

Your assistance was greatly appreciated.

Ed

Okay - it *DID'NT* work! The reason it worked the first time was that the Text to Display was seen as a local path, but the actual File to Link TO was still the network path.

On the CD, I have New Folder. Inside is my Excel file with hyperlinks to Word docs and the folder ("Narratives") containing those docs. The hyperlinks all show AND link to \\Narratives\'docname'.doc ('docname' is actually the document name).\

BUT -- "Cannot open specified file."

Any help is appreciated.

Ed