RecursiveFileSearch filePattern fails when "_" in filename

[gwsampso]

Looking for some help with my macro that loops through subfolders and brings back data from the workbooks that match my filename pattern, because the name changes each month.

It works seemlessly if the pattern is "[0-9][0-9][0-9][0-9][0-9][0-9] Filename"

But fails if "[0-9][0-9][0-9][0-9]_[0-9][0-9] Filename"

any ideas on how to handle the underscore?

Thanks heaps
GWS


Fullcode

Please Login or Register  to view this content.

[gwsampso]

Any ideas welcome please!