Excel VBA: Search folder and sub-directories for files matching partial string

Thanks, Norie. I just read about that and I also revised the code. Here is the initial sub:

Please Login or Register  to view this content.

The relative functions:

Please Login or Register  to view this content.

I've revised the OP code and removed the unnecessary inner loop. When it finds the file, it starts the procedure to carry the value to the worksheet, but then exits to the GetSubFolders func and resumes the next search. Even if I change it to Folder.Path it still jumps back into the GetSubFolders func.

I've attached the workbook with code.

In this example, there are 3-4. For the final project, there could be several deep.

I think I'm going to use the Recursive Folder Search from Ammara Digital Image Solutions. That seems to be producing the output I need. I think I can retrofit it to do what I need it to do.

Tangent: this is something the OS generally does better than VBA even using Windows Script Host objects.

For what it's worth, the following batch file produces CSV output with the desired information.

Please Login or Register  to view this content.

My point in mentioning this is that you could keep batch files in ranges in very hidden worksheets, write them to disk and run them as needed, redirecting output to files when running them, opening or importing the files created, and finally deleting those ad hoc files.

Going on a different tangent, you could include a VBA project reference to the Windows Script Host (WSH), namely, scrrun.dll, to make its classes' properties and methods available in the VBA Editor as if they were built-in classes. Then you could use

Please Login or Register  to view this content.

as well as using the actual object types for all the WSH classes.

Fascinating. I have a very rudimentary understanding of batch files. I only use them strictly for backing up my directories. haha. I've seen some examples on SO and I have much to learn.