VBA Macro to loop through folders and select files with certain criteria

[sbl56vikes]

I'm looking to create a macro that does the following:

1. Loops through a folder structure
2. Opens a specific subfolder within each folder based on name (i.e. "*Financials*")
3. Opens a specific file within that subfolder "*Financials*" based on both most recently modified a naming criteria (i.e. "*Model*")
4. Performs an action on that file (a macro created elsewhere that I assume I can call here)
5. Closes that file, and moves on to the next file matching the criteria above

As a self-diagnosed VBA novice, I'm having trouble adapting code found in various forums for my specific project.

I've found examples that address aspects of my desired macro or do similar things, but I can't figure out how to put them together.

Open most recent file:

Please Login or Register  to view this content.

Loop through folders and subfolders and print all files:

Please Login or Register  to view this content.

Any help is greatly appreciated.

[Tsjallie]

Would this get you up and running?
Run the macro SearchThroughFolders() and enter the folder containing the subfolders you to search for the files you want to process.
I marked the location where you could call your macro.

BTW: if you need any additional help, please know that after next Sunday I will be away for the next 3 weeks and not able to answer your posts.