Referring to a workbook with constantly changing name and date

Hi, everybody!

I have a formula that contains reference to a table in another workbook.
The problem is that the other workbook is replaced every week with a new version. The table's format remains the same but the data and the file name changes in every new version.

The file name changes in the following manner - "New Table 09.03.2017" to "New Table 16.03.2017"

So I need to either write a macros that either:

1) refers to a table in the most recent workbook (with the latest date modified)

or

2) refers to a table with the newest date in the file name

How can I write a macros for this?


Thanks in advance!

Originally Posted by JBeaucaire

NewTable.xlsx.

Then maybe a macro that searches a given folder, finds the most recent one using whatever logic you deign, and once that is settled upon, makes a copy of that file to replace the NewTable.xlsx

I see. Is there a ready macros that finds the most recent file in the excel folder?