Wildcards in a File name

[t0m46]

Hey all

I have some code that lookes through a folder to find a file. the thing is that the start of the file name is the a date so will change each week but the end of the file name is always the persons name.
I want to have a macro to open the file, how can i do this using a wildcard so that the macro will work each time it changes.

the code i have now is

Please Login or Register  to view this content.

that doesnt seam to work. do you have to put the wild card in differently.

thanks

[royUK]

I think you might find it simpler to use the open file dialog to allow selection of the file

[t0m46]

I want to get the data from multiple files and dont really want the user to have to do much. basicaly i want to open a workbook copy the data to another workbook, close it and then open another 1 and copy the data to the same workbook and add it to the other data. i have to do this about 10 times. is there another way to do it?