BuiltinDocumentProperties Property

Applies To

Workbook object.

Description

Returns a DocumentProperties collection that represents all the built-in document properties for the specified workbook. Read-only.

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).

You can refer to document properties either by index value or by name. The following list shows the available built-in document property names:

  • Title
  • Subject
  • Author
  • Keywords
  • Comments
  • Template
  • Last Author
  • Revision Number
  • Application Name
  • Last Print Date
  • Creation Date
  • Last Save Time
  • Total Editing Time
  • Number of Pages
  • Number of Words
  • Number of Characters
  • Security
  • Category
  • Format
  • Manager
  • Company
  • Number of Bytes
  • Number of Lines
  • Number of Paragraphs
  • Number of Slides
  • Number of Notes
  • Number of Hidden Slides
  • Number of Multimedia Clips
  • Hyperlink Base
  • Number of Characters (with spaces)

Container applications aren't required to define values for every built-in document property. If Microsoft Excel doesn't define a value for one of the built-in document properties, reading the Value property for that document property causes an error.

Because the Item method is the default method for the DocumentProperties collection, 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