ExcelBanter - Reference the document properties in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Reference the document properties in a cell (https://www.excelbanter.com/excel-worksheet-functions/47887-reference-document-properties-cell.html)

McVeigh

Reference the document properties in a cell

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

On Thu, 29 Sep 2005 13:46:04 -0700, "McVeigh"
wrote:

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

All times are GMT +1. The time now is 08:16 PM.