excel summary properties

[jpritchard]

hi,

sorry - this is a stupid question but can anybody point me to the propertys within excel for the last modified datetime/last modified by fields. (you know all that junk U can add via a right click - summary)

I cant them - have checked the forum/ used the object browser etc etc. its probably easy and I am being blind or stupid.

just need pointing in the right direction

(want to get to them via vba within excel)

many thanks, AJP

[jpritchard]

oh hum....

got to http://msdn.microsoft.com/library/de.../D4/S5A92C.asp

splendid

until i found that all the properties work - except that the last modifed seemed to show old dates...

dunno

in the end used the fso for that one...

[alex_read]

MsgBox FileDateTime(ActiveWorkbook.Path & "\" & _
ActiveWorkbook.Name)

Should give you the date the file was created if the workbook has not been saved or only saved once, or the date last modified if it's been saved afterwards...