Open newest folder and specific file in the folder

Hi guys,

Could someone advise me on the following please.

I would like to automatize manual process of opening a specific file in a specific folder.

In location: "\\test\UK_test\reports\" folders get created each day, for example today: "\\test\UK_test\reports\05.05.2017\" ...this folder "05.05.2017" contains a specific excel file called"ratios_20170505" which I have to open and copy data from.

Tomorrow new file will be created in this location, for example: "\\test\UK_test\reports\06.05.2017\" and the name of the file inside will be "ratios_20170506"

Ideally I would like to write a macro that would always locate the latest folder and open the file which name starts with "ratios_xxxxxxxx" ?

Many thanks for your help once again.

Let me know if you need any other details.

Best,
Seb