Need VBA code to search file in directory and sub-directory and show result

Hi to all,

I have here a working code that will search and display files matching a certain string in a directory (.e.g. "Structural analysis.pdf") . However, I can't get around to have it search in sub-directories as well. Unfortunately, i'm just a beginner with excel vba, can someone help me ? I would like it to show the path to the files as well if possible. Thanks a lot and appreciate it !!

JCC

************************************

Please Login or Register  to view this content.

********************************************

JCC,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.