use Wildcard in file name

[doriannjeshi]

Hello,

I need to create a macro that copies data from a workbook that the name will change and a fixed sufix i.e: 22034202_name.xls
how should I go with using the wildcard in the file name?

 

[doriannjeshi]

It will open the first found file.

If you have not too many files, I would look at a UserForm with Listbox populated with filenames where you can select from.

it is a file with a diferent name and constant
then I want to copy from them

 

[jolivanes]

Just change the part of the name you know.