file properties

A

Adde

Is there a way to extract information about the creator of a document and
when the doc was saved and edited beyond the info that is available in the
Summary under the document properties?

I have tried using low-level binary editor but cannot even get all the info
from the Summary…

Any suggestions?

/Adde
 
C

CLR

With VBA you can use the BuiltInDocumentProperties Property........

or, here's a Function I think came from Bob Phillips a while back

'----------------------------------------------------------------
Function DocProps(prop As String)
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function
'----------------------------------------------------------------------

hth
Vaya con Dios,
Chuck, CABGx3
 
Top