Applies To
Workbook Object.
Description
Returns a DocumentProperties collection object that represents all the built-in document properties for the specified workbook. Read-only.
To use this property, you should establish a reference to the Microsoft Office 95 Object Library by using the References command (Tools menu).
Remarks
This property returns the entire collection of built-in document properties. Use the Item method to return a single member of the collection (a DocumentProperty object) by specifying either the name of the property or the collection index (as a number). For a list of valid built-in document property names, see the Item method.
Because the Item method is the default method for the DocumentProperties collection object, the following statements are identical:
BuiltinDocumentProperties.Item(1) BuiltinDocumentProperties(1)
Use the CustomDocumentProperties property to return the collection of custom document properties.
Example
This example displays the names of the built-in document properties as a list on worksheet one.
rw = 1
Worksheets(1).Activate
For Each p In ActiveWorkbook.BuiltinDocumentProperties
Cells(rw, 1).Value = p.Name
rw = rw + 1
Next