Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Document Properties
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Document Properties
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Document Properties | Excel Discussion (Misc queries) | |||
Properties of a document, help! | Excel Worksheet Functions | |||
Document Properties | Excel Worksheet Functions | |||
Document properties | Excel Programming | |||
Document properties | Excel Programming |