This file might be a help:
http://www.bygsoftware.com/examples/...Properties.zip
The workbook has a family of VBA routines to help you create, amend, and
delete Custom Document Properties
It's in the "Administration Utilities" section on page:
http://www.bygsoftware.com/examples/examples.htm
The code is open and commented.
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"Ruan" wrote in message
...
Hello,
Is it possible to display the Builtin Properties "Title"
and "Subject" of an Excel workbook to a specific cell?
I use the "Subject" line for version control. Everytime I
make modifications to the Workbook, I update the version
number and date in the "Subject" line.
Thanks
Ruan