Search for files in folders and subfolders

Hi Rick,
Look at "Application.FileSearch", it has a handle for SubFolders - ".SearchSubFolders="True".

Good luck
- Jewel

Hi Rick,

I believe Jewel is correct.

See post #3 in the following thread which probably will help you.
http://www.mrexcel.com/forum/excel-q...ilesearch.html

Lewis

Please note that when searching for "*.xls", files with extensions ".xlsm", ".xlsx" also apparently show up as matches. It seems to be a legacy feature of Windows that 8.3 extensions are matches and other characters in the extension beyond character 3 don't matter.

See http://www.networksteve.com/windows/...=16743&Posts=6

A possible workaround could be the 'like' command:

Please Login or Register  to view this content.

Lewis