VBA extracting data from workbooks but the workbook name will always change.

[BrianG86]

Hi

I have to extract data from a workbook daily to paste it into a master workbook. The problem I have is that the workbook I am extracting from will have a different name each day (the workbook will be saved with the date). Can I program VBA to extract it without having the exact file name?

 

[BrianG86]

Just to clarify, these files will be stored in the same folder but the file name will change slightly with the date changing for each daily file.

Can anyone help?

Thanks