loop through files in a folder based on partial name from worksheet cell

I need a macro to open all files in a folder that have the value in a cell somewhere in their filename. The files will be opened and closed one by one to copy some info and paste into the active workbook. Here's something to give you an idea what I'm after:

Please Login or Register  to view this content.

Thanks yudlugar, do I need to set 'fil' to anything?

It should assign it to the files in the folder (the line 'for each fil in fol.files' does this) and loop through them. You do not need to define it outside of the loop.

Hmm, i can tell it's close but it actually doesn't open anything, and then it closes the "console" workbook.

How about:

Please Login or Register  to view this content.

Thanks yudlugar! the first one actually worked, I just had to adjust my 'criteria' values.

Best regards,

Willardio