How do I auto-enter the creation date in footer of an Excel worksh

[Youngergirl44]

I know how to set up the current date to appear in the footer, that's simple.
I'm looking for something like the "Insert Field" command in Word 2003 -
where the date that appears is the creation, last saved or last printed date,
not the current date. Is this possible?

 

[Ron de Bruin]

You must use code to do this

See this page for a example
http://www.rondebruin.nl/print.htm#Saved

 

[samearle]

View Menu
Header and Footer
Custom Footer..... date, day file name, whatever.

S.

 

[Youngergirl44]

This looks like it should do the trick... I'm not familliar with the code
side of Excel. How could I change your example to show a creation date
instead of a last saved date?

 

[Ron de Bruin]

Highlight this word "BuiltinDocumentProperties" in the VBA editor and press F1

you see the that you can use "Creation Date"

See also
http://www.cpearson.com/excel/docprop.htm

 

[Youngergirl44]

That's it! Thanks for your help!

Highlight this word "BuiltinDocumentProperties" in the VBA editor and press F1

you see the that you can use "Creation Date"

See also
http://www.cpearson.com/excel/docprop.htm