
Excel-VBA: BuiltInProperty "Last Save Time" doesn't work
Excel (and all Office apps) have the same suite of BuiltInProperties
(did you see "Number of Slides"?). Excel, however, at least through
Xl200(0|1) doesn't maintain them.
Chip Pearson has a full discussion and workarounds at:
http://cpearson.com/excel/docprop.htm
Quote:
> The Code:
> For Each p In ActiveWorkbook.BuiltinDocumentProperties
> Debug.Print "Name:" & p.Name
> On Error Resume Next
> Debug.Print "Value: " & p.Value
> On Error GoTo 0
> Next
> results in a list of the document properties. Some of them work, but the one
> I need
> "Last Save Time" returns in a runtime error (in the code above there's no
> line with "value: ")
> The document IS saved and HAS a date of the last change in FILE / PROPERTIES
> Any ideas?
> Thanks in advance!
> Bernhard
--
ROT13 encoding, decode for real mail