Workbook.CustomDocumentProperties (Excel)

Returns or sets a DocumentProperties collection that represents all the custom document properties for the specified workbook.

This property returns the entire collection of custom 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). Because the Item method is the default method for the DocumentProperties collection, the following statements are identical.

Dim dpsCustomDocumentProperties As DocumentProperties
dpsCustomDocumentProperties = ActiveWorkbook.CustomDocumentProperties