Hey all. Thanks in advance.

Here is my issue: I am working with an Excel file that will need to create a data connection to another file and import it into a tab titled "Master Staff". The file location will always be the same, but the file name will change, based on date. It will have the following naming format: "* MM-DD-YYYY HH-MM-SSSS".

I am really having trouble figuring out the VBA coding for this. The date/time will always change and I want to pull the file with the name that is closest to Now().

Any thoughts?