How to Identify the newest file in a directory

[captphan]

I need to get the name of the file that has been most recentely saved into a folder.
Twice a day a file is added to a folder. It always have the same naming convention and all the files in the folder have the same convention.

NameDate_Date_Time

I am trying to automate a process that currently has the user selecting the file to import. How do I retrieve the name of this new file.

 

[HughLerwill]

You may find the FileDateTime Function useful; check it out in VBA help.