Hi,

Am Tue, 24 Jul 2012 15:54:32 -0700 (PDT) schrieb :

scratch the above i have done some mroe playing and it appears the value ActiveWorkbook.BuiltinDocumentProperties.Item(11). Value is the content created date not the date created date in the properties menu

though i am getting an error

method value of object documentproperty failed

try:
ActiveWorkbook.BuiltinDocumentProperties(11)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2