0) Get a date variable for latest date, and string variable for file.
1) Loop through the excel files.
1.1) Get the last 8 characters of name of the file. Ref:
GetFileNameWithoutExtension[
^],
SubString[
^]
1.2) Convert them to date. Ref:
Convert.ToDateTime[
^]
1.3) If it is newer then latest date or latest date is null then store date in latest date, and file name in file variable.
2) When you are out of loop, you'll have the latest file in the file variable.