Marianne,

The "List Files" program only provides hyperlinks to files not folders.
However, if you select a folder name in the list and click the
orange/tan bar at the top of the list the folder opens.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"marianne"

wrote in message
...
thank you for the link. I tried the add-in but it takes too long and the
links don't work.

Marianne

"Jim Cone" wrote:

The free Excel add-in "List Files" will list files or folders from specified directories.
Download from... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA

"marianne"
wrote in message
I need to be able to create a list of folders in a directory in an excel
spreadsheet. The spreadsheet is basically an index for users to use rather
than navigating through Windows Explorer.
I've tried different code off the web, but can't seem to find what I need.
Can anyone help me please?