Diane,

My Excel add-in "List Files" does that.
Files and folders in the specified folder, directory or drive are listed.
Files in sub-folders are listed if requested.
Specific file types or names can be listed. (*.pdf, *.wav, etc)
Each file name, size, date and type go on the list.
Each file name on the list is hyperlinked.
All arranged in columns and rows that can be sorted.
Available - free - upon direct request.
Remove xxx from my email address

Regards,
Jim Cone
San Francisco, CA



"Diane Mallin" wrote in message

...
I have a macro which will find a given directory - what I would like to be
able to do is to pick up a list of all the files in the directory and list
these in an Excel worksheet - starting at A1 and continuing down to A20 (if
there are 20 files listed in the directory)
Cheers
Gazza