View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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...