Reference the document properties in a cell

[McVeigh]

I would like to have a cell or cells show what is stored in the document
properties. How would I do this?

 

[Gord Dibben]

McVeigh

Check out Bob Phillips' UDF's at his site.

http://www.xldynamic.com/source/xld.DocProps.html

Note different UDF for regular properties and for custom properties.


Gord Dibben Excel MVP