Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,