Redge,

Sounds like the free Excel add-in "List Files" will do what you want.
Download from here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


wrote in message...
Hello
Can anyone help me with a macro that will go to a particular folder in
Windows explorer and list all the files in one column of an excel
spreadsheet and the path to the file from that folder in another
column. I need this to work on sub-directories so effectively creating
an inventory of files and their paths.
Any ideas or help will be much appreciated!
All the best
Redge