View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] redog6@hotmail.com is offline
external usenet poster
 
Posts: 5
Default 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