Printable View
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
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...
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...VB Code: