Count Property (DocumentProperties Collection)

Applies To

DocumentProperties Collection.

Description

Returns the number of document properties in the DocumentProperties collection. 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).

Example

This example displays the number of document properties in a collection. You must pass a DocumentProperties collection to the procedure.

Sub CountDocumentProperties(dp As DocumentProperties)
    MsgBox "There are " & dp.Count & " properties in the collection."
End Sub

This example displays the number of custom document properties in the active workbook.

MsgBox ActiveWorkbook.CustomDocumentProperties.Count