Importing a file date

[Kris]

I am running Access 97 and have a liked table to a file
that I have exported (.mdb format). I want to import
the “date modified” value of the import file. Any
thoughts?
Thanks

 

[John Nurick]

Hi Kris,

I'd use the FileSystemObject object for this. Set a reference to the
"Microsoft Scripting Runtime" library. The FileSystemObject is described
in the VBScript help file VBSCRIP5.CHM.

Something like this:
Dim fso as Scriptng.FileSystemObject
Dim fiF as Scripting.File

Set fso = New Scripting.FileSystemObject
Set fiF = fso.GetFile(strPath)
dtLastModified = fiF.DateLastModified