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
|