Problem with Document Properties
This is from VBA Help. It might be what you are looking for.
Sub ShowFileAccessInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = UCase(filespec) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
MsgBox s, 0, "File Access Info"
End Sub
"jasminesy" wrote:
Okay...I'm seeing that i need Dos or the windows properties...can/how do you
retrieve those...
"jasminesy" wrote:
the BuiltInDocumentProperties("Creation Date") is returning the original date:
i.e. if you write a doc and saveAs 2 months later and save as another 2
months later it is returning the original date from four months ago...however
the file/document properties says it was created on the latest date...
I need the latest date....any ideas...
|