VBA Opening latest file (Multiple same name)

[jsneak]

Hi all,

I've written some code that looks at a specific file in a folder, which all works fine... but i want it to open the latest one, the below currently opens the first one of that day

Please Login or Register  to view this content.

***FileStructure - PunchDataExport_20200124_07**** <- 2 digits after the _ is the hour

I know I've added the "*", it does the same thing without it... The files aren't at specific times either, but it does run everyday

Any one got any ideas?

Thanks!

[jdop]

Sort the filenames in an array including the time of day and pick up the latest one out of the array