tried it but still no joy. Placed the filename in the first argument and
the text for the cell in the second argument. The response - cannot open
the specified file.

Perhaps I should explain the structure that I am working with?

Main Folder - Test
contains 4 folders - 611, 613, 614, Admin Docs
All of the above will be operated from either a CDRom +RW or DVD +RW
The Hyperlink is required to 'open' a file be it .doc, .xls, .pdf or .html
These documents will be closed in the normal fashion.
The hyperlinks are in cells which relate to the documents viewed like a list
but sorted into groups matching the folder 611, 613 etc.
Does this help at all?
--
D Rodman


"Bill Manville" wrote:

You still have the arguments wrong.
The FIRST argument of Hyperlink is the filename you want to link to.
The second argument is what appears in the cell.

=HYPERLINK("C:\Temp\MyFile.doc", "My File") will show My File in the
cell, in hyperlink format, and will link to the file specified when you
click the cell.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup