Programming Excel with VBA and .NET

Name

workbook.BuiltinDocumentProperties

Synopsis

Returns the collection of Excel’s built-in document properties. In some cases, properties may not be initialized, so you must use error handling when getting their values. The following code displays the names and settings of all of a workbook’s built-in properties:

Dim prop As DocumentProperty
On Error Resume Next
For Each prop In ActiveWorkbook.BuiltinDocumentProperties
    Debug.Print prop.Name, prop.Value
    If Err Then Debug.Print prop.Name, "Not set."
    Err.Clear
Next
On Error GoTo 0