Getting a list of files and checking date & time stamp

[BradEdwards]

I work for a bank and every night we have a program that connects to all 24 branches and downloads a file called 'Journal.mdb'. When I come to work in the morning I need to check all the date & time stamps of the files to make sure that they are yesterday's date and the time is after 5:00 PM. If they are not then I need to download the ones that aren't. I would like to create a vba program in Access that runs after the download is complete that checks each file and if they check out ok then run some other code that consolidates these "journal.mdb" files together. I created a table with a list of file paths and I need to write some code to check these files' date & time stamp to make sure that they are greater than a specified date and time. Can anyone give me some sample code that would do that? I would appreciate it.

Example:

tblBranches

Fields: Branch, Path

Tipton f:\fast\branches\Tipton\Journal.mdb
Logansport f:\fast\branches\Logan\Journal.mdb
Carmel f:\fast\branches\carmel\Journal.mdb
etc......

The code needs to get the date & time stamp of each file listed in this table and check to make sure it is greater than yesterday's date @ 5:00 PM.

If you need more information just let me know. I apologize for being so windy Thanks in advance.

Brad [sig][/sig]

 

[BradEdwards]

Nevermind, I figured it out. Thanks anyway. [sig][/sig]

 

[sinyce]

How?