vXP Grabbing and storing the date modified on a file 1

[mastro78]

I currently have a database that pulls in Excel data from various Excel spreadsheets based on if various unfilled cells are then filled. What I'm looking to do now is write a code that will remove all the data in an Access table associated to any/all Excel files where the name of the file is the same as the previously pulled one, but the date modifed changed. Any suggestions? Thank you.

 

[JerryKlmns]

No extra refferences needed

Dim fso As Object 'Scripting.FileSystemObject
Dim f As Object 'Scripting.File
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(Full_Path_To_File & File_Name)
MsgBox "Date Last Modified is: " & f.DateLastModified
Set f = Nothing
Set fso = Nothing

 

[mastro78]

Thanks. What would be a way to store the date modifed in a table in Access (table name Spreadsheets as an example). That table currently stores the file name but no other information. The fields in that table are Spreadsheets for the file name and Date for the Date modified.

 

[JerryKlmns]

mastro78

How do you store the file names in the table?

BTW Date is a reserved word for Access. Consinder changing it.