In various cells on a worksheet, I need to capture the information entered
into the Document Properties fields. i.e. I need to capture Title and used
the formula =DocProps("Title") but this returns the error #NAME?

Any ideas??

Thanks

Derek

See response in excel.misc newsgroup.

No need to multi-post to these Excel newsgroups.

All the regulars monitor all groups.


Gord Dibben MS Excel MVP

On Tue, 25 Sep 2007 07:44:02 -0700, Derek
wrote:

In various cells on a worksheet, I need to capture the information entered
into the Document Properties fields. i.e. I need to capture Title and used
the formula =DocProps("Title") but this returns the error #NAME?

Any ideas??

Thanks

Derek