using wildcards in vba

[p4nny]

Hi

I have the following path:

FileCopy Source:="\\retail\$test\Group \AllAreasExcCO\01-01 UAT.xlsx"

How do I use a wildcard here so rather specifying "01-01 UAT.xlsx" it would consider anything that matched "01-01" &."xlsx"

TIA

 

[Joe4]

If you want to do multiple files, you would need to loop through them.
See here: https://www.mrexcel.com/forum/excel...-through-folder-find-files-specific-name.html