insert metadata

[Mike Morisoli]

I am trying to find out how to include the Excel metadata into a worksheet.



In Word, it would be called a field and can be inserted by clicking Insert,
Field, Document Information, DocProperty and then selecting one of the
various properties including any custom fields.



I am unable to find the equivalent in Excel.



Thanks, Mike

 

[Dave Peterson]

Excel doesn't support this directly. But you could use a userdefined function
to retrieve either builtindocumentproperties or even CustomDocumentProperties.

Here's one by Chip Pearson that does both:
http://google.com/[email protected]
(one line in your browser)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm