After further tinkering. I finally be able to get what i want by passing this as the criteria in the filename
however your solution helped me to determine the latest excel file name in the folder and I am able to continue the process with that file
Thank you