Importing a file date

  • Thread starter Thread starter Kris
  • Start date Start 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
 
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
 
Back
Top