View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default How do I auto-enter the creation date in footer of an Excel wo

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Youngergirl44" wrote in message
...
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" wrote:

You must use code to do this

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Youngergirl44" wrote in message
...
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?