macro to list file name and path in separate cells
 

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

macro to list file name and path in separate cells
 

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

macro to list file name and path in separate cells
 

That sound very useful Jim - I will give it a try many thanks!

macro to list file name and path in separate cells
 

It certainly does the job - how easy would it be to adapt the macro to
display the documents' built in properties alongside in addtional
columns?

Thanks
Redge

macro to list file name and path in separate cells
 

Redge,

It would not be easy to add DocumentProperties to the
List Files program.

If you want a song list, John Walkenbach has a free workbook
that will display all of your MP3 files and most of the information
about them...
http://www.j-walk.com/ss/excel/tips/tip103.htm

If you actually want the document properties, then Chip Pearson
provides the VBA code here...
http://www.cpearson.com/excel/docprop.htm

Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



wrote in message ups.com...
It certainly does the job - how easy would it be to adapt the macro to
display the documents' built in properties alongside in addtional
columns?
Thanks
Redge