Edit

Workbook.BuiltinDocumentProperties property (Excel)

  • Article

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

Syntax

expression.BuiltinDocumentProperties

expression A variable that represents a Workbook object.

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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.