Detecting the last time a file was modifyed in excel before importing (1 Viewer)

[Mcgrco]

Does anyone have some code that will detected the last time an excel file was modified before importing in Access . We receive a file sporadically so I want the process to ignore the import if the modified date is the same as the previos day. Im thinking of storing the the modified date in a table. If anyone can think of a better way of doing this it would be a great help

Any help is appreciated

 

[brianb]

Have a look at the FileDateTime property.

 

[Mcgrco]

Very Helpfull thanks