How to get date and time a file has been created

[dorisr]

Hi everyone,
I'm looking for a way to go get the date & time that a file has been created or updated...

I have made a macro to go get a comma delimited file and imported the data in a pre-define table. But It will be nice before to go get the date & time that file has been created before the imported macro procedure.

Is there a way to program that code in vb access ?

Please if you know how to do this ,,, help me.

Thanks,
Doris

 

[namliam]

Try to make heads or tails from this

http://vbnet.mvps.org/index.html?code/fileapi/filedatetime.htm

Should get you started atleast.

 

[dorisr]

Thanks for your reply.

I have found this simple code that do it also :

Dim pathname As String
pathname = "C:\testfile.txt"

mystamp = FileDateTime(pathname)
MsgBox (mystamp)

This return the date and time of creation or last update.

Thanks again for your time.
Doris

 

[gemma-the-husky]

amazing which little known functions are there when you start digging around isnt it.