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

That's it! Thanks for your help! :)

"Ron de Bruin" wrote:

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?