This VBA sample code will get a list of all files in a folder and subfolders and write the output to a sheet together with some other files metrics, size, date modified, etc.
e.g. "Folder Path:" "Folder Name:" "Size:" "Subfolders:" "Files:" "File Names:"
Full article and code are on our forum Excel VBA list all files in a folder & subfolder - fracta.net forum
This download is a full working sample to save you doing the coding.
This product was added to our catalog on Sunday 17 September, 2023.