how many custom properties has a document?

[Medes]

Hi,

I want to check how many CustomProperties has a word or Excel document.

how can i do it?

 

[Andy Pope]

Hi,

Excel:
?activeworkbook.CustomDocumentProperties.count

Word:
?activedocument.CustomDocumentProperties.count

Cheers
Andy

 

[Medes]

Thanks Andy,

but there is no count on activeWorkbook.CustomDocumentProperties. .....


"Andy Pope" skrev:

 

[Andy Pope]

It works for me, have you tried it?

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

And the DocumentProperties Collection has the following properties;
Application Property
Count Property
Creator Property
Item Property
Parent Property

Cheers
Andy