retrieving File create date in Access VBA

D

diddy_david

my access project links to documents (eg scans, word docs etc) in a folder.
the project the filenames in the folder and then displays these in a form.
How can I retrieve the date these files were created?
 
B

Bob I

From Visual Basic Help:

Sub ShowFileInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = "Created: " & f.DateCreated
MsgBox s
End Sub
 
Top