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?

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?

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?

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?

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?

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

S.