Search for files, then return file path

Hey guys.

I was wondering if you could help me out here.
I have a list of names and I want to search specific folders for any filenames that contains that name and then return the filepath to those files into Excel.

The list of names I have look like this:

07_0088
08_0086
20-07-00889-01
etc..

Then I have a cell which contains the filepath.
Like:
C:\My Documents\


So what I want the macro to do is to search for all files in a given path where the filename
contains *07_0088*. Then return the full filepath back into an Excel sheet.
Something like:
C:\My Documents\07_0088_CR.xls
etc.

I have made something like this before, but that macro only returns one file (the first one it finds). I want something that can look for multiple files and return all results.


Any help will be MUCH appreciated

Hello Carlsbergen,

I have made a correction to Antonio's macro. This work now.

Please Login or Register  to view this content.