DocumentProperties Collection Object (Microsoft Office 95 Object Library)

Description

Represents a collection of document properties. Each document property is represented by a DocumentProperty object.

To use this object, you should establish a reference to the Microsoft Office 95 Object Library by using the References command (Tools menu).

Accessors

Each workbook has a collection of built-in document properties and a collection of custom document properties. Each collection is represented by a DocumentProperties object, and each collection contains individual DocumentProperty objects.

Use the BuiltinDocumentProperties property to return the collection of built-in document properties, and use the CustomDocumentProperties property to return the collection of custom document properties.

Use the Add method to create a new custom document property and add it to the collection (you cannot create a built-in document property).

The following example creates a list on worksheet one of all the built-in document properties for the active workbook.

rw = 1
Worksheets(1).Activate
For Each p In ActiveWorkbook.BuiltinDocumentProperties
    Cells(rw, 1).Value = p.Name
    Cells(rw, 2).Value = p.Value
    rw = rw + 1
Next

Properties

Count Property (DocumentProperties Collection), Parent Property (DocumentProperties Collection).

Methods

Add Method (DocumentProperties Collection), Item Method (DocumentProperties Collection).