Using VBA, I have a script which grabs the latest file from the server. It uses a wildcard to grab the correct titled file and the get - latest pulls the most recent.
I need to expand this so that it only pulls the latest file with the current days timestamp.
This is so that on the next day, it doesn't grab one of the files that would have been grabbed yesterday if a newer file has not been created on the server. Yesterdays file have been processed and removed locally and we do not want them processing again.
I assume I need to something like this but am unsure of the syntax:
- Get todays date
- Get the latest file with todays timestamp