How do I HYPERLINK to a FOLDER?

[XLML]

I want to click on a cell and have it open a certain FOLDER in Windows Explorer. I know how to right click on a cell, choose HYPERLINK and browse for a particular file in that folder. However, how would I have a certain FOLDER open listing all the files in it (through Windows Explorer)?

Thanks,
XLML

 

[ddp2049]

One thing you may want to do is to figure out the path to the folder you would like the hyperlink to open. To do so, right click the folder and select properties. there you can copy the exact path. Once you know that, go back to your hyperlink edit screen and paste the path into the 'type the file or web page name' line. Hopefully this will work for you.

This solution was great. Thanks for posting it.

 

[Mishack40]

Hi,

Can it also be possible to hyperlink to a file in another folder? as hyperlink works fine with opening the whole folder. What about a specific file in another folder?