I am trying to open a specific file from the same folder which contains the macro enabled sheet using the following code:

Workbooks.Open (ThisWorkbook.Path & "\abc xyz_dd_mm_yy.xlsx")

Now, every week the dd_mm_yy section of the file name will change and "abc xyz" portion will remain the same. Is there a way, that I can open any file which contains "abc xyz" in the filename using VBA?