Get date file 2

[juanferman]

How can i know the date of a file ?

Thanks
===================
: Juan F. Sarria

 

[Jon4747]

Hi Juan,

Try using the FileDateTime function
e.g.
FileDateTime(pathname)

Jon

 

[jitter]

If you need more than just the last modified date you could use the File System Object:


Dim objFSO As New FileSystemObject
Dim objFile As File
Dim dtCreated As Date
Dim dtLastAccessed As Date
Dim dtLastModified As Date
Dim strPath As String

strPath = "c:\test.txt" 'this is the file we want information about

Set objFile = objFSO.GetFile(strPath)
dtCreated = objFile.DateCreated
dtLastAccessed = objFile.DateLastAccessed
dtLastModified = objFile.DateLastModified

MsgBox "File: " & strPath & vbCrLf & _
"Created: " & dtCreated & vbCrLf & _
"Last Accessed: " & dtLastAccessed & vbCrLf & _
"Last Modified: " & dtLastModified & vbCrLf & vbCrLf & _
"Thank you, Come again!"


Set objFile = Nothing
Set objFSO = Nothing


Probably a better way to do this but this might help you out....