List of File Names

[tphillips]

I have a lot of files in a folder. I need the text for each file name so I can paste it in a spread sheet. Is there a macro that will read files in a folder and save it to a text file? Or maybe pull the file name directly into the spreadsheet?

Thanks

 

[ADAMC]

See here:

http://support.microsoft.com/kb/306248

and here:

http://www.cpearson.com/excel/FolderTree.aspx