Copy all files containing certain text from one folder to another

[JJGF]

This code works but only copies the first file that meets the partial file name criteria and then stops, how can I get it to find and copy all that meet criteria & "*" & range("A1")

Please Login or Register  to view this content.

[LJMetzger]

Hi JJGF,

You probably need a loop similar to the following (non-working code excerpt):

Please Login or Register  to view this content.

For a working example(including downloadable file) see post #2 in the following thread: http://www.excelforum.com/excel-prog...in-folder.html

Lewis