Worksheet properties question

[Diane K]

Is there a way to extract info that is in the File>Properties box such as
subject or author, and place it into the worksheet? What I really want to do
is have the value in a custom field in the Properties box, show up on a
worksheet cell.

Thanks,
Diane

 

[JW]

Have a look at Chip Pearson's page regarding this.
http://www.cpearson.com/excel/docprop.htm