Importing a file date

K

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
 
J

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
 
Top