filesystemobject

[Guest]

hi,

I am trying to get the datecreated for a specific csv file.

I am using the following, but I am unsure of what to do with this or where
to go. If the file was created on a specific day, then I want to run another
code or something. But I just need to know how to retrieve the filecreated
date and put it in a form field.

Dim fso As FileSystemObject
Dim mydrive As Drive
Dim path As String
'Initialize path.
path = "C:\"
'Get object.
Set mydrive = fso.GetDrive(path)

'Check for success.
MsgBox mydrive.DriveLetter 'displays "C"

Thanks in advance,
geebee

 

[Guest]

Check out the FileDateTime function in VBA Help. It may be what you need.