Thanks all - advice much appreciated

"Tom Ogilvy" wrote in message
...
also see the help example for the Dir command

--
Regards,
Tom Ogilvy

"Skip" wrote in message
...
Hello all,

I've seen various Macros that will list files in a Directory. I'm
looking
for a Macro that will list subdirectories in a directory. I would like
the
Macro result printed to a blank sheet in a single column just containing
the
sub-directory name. It only needs to go down 1 level - don't need
sub-directories in sub-directories. The plan is to use this data to
populate
a listbox - unless the listbox could be populated directly.

Is this possible?

Many thanks.

Paul.