Loop through files with dynamically changing dates

I have the below files that are dropped into a folder each day. How do I write a macro so that it will open each file each day.

For example the file name of the first file today is U2714866_20190308_20190308, but tomorrow, the file will be called U2714866_20190311_20190311

Thanks.

Capture.PNG

Perhaps something like this

Please Login or Register  to view this content.

Norie, yes they will be the only files in the folder.