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"
<marianne@discussions.microsoft.com>
wrote in message
news:121D3995-DC1F-4642-8FD7-56EF7770F028@microsoft.com...
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" <marianne@discussions.microsoft.com>
> 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?
>