How to capture file folders and file names to spreadsheet

[devo]

I know this seems simple but could you some help:

I have several folders and files out on a network drive - I want to create an audit so I would like to have the folder names and the file names inside those folders in a spreadsheet- how can I capture this data.

 

[staticbob]

Re: How to capture file folders and file names to spreadshee

See this post . .

http://www.mrexcel.com/board2/viewtopic.php?t=70445

You can then lift the data out of notepad and do a bit of text to column conversions.

Bob

 

[devo]

Re: How to capture file folders and file names to spreadshee

Thanks, that did the trick. I really did not want to type 120 folder names and 1300 file names. an added bonus was it also captured the file date, time and size