software

I know how to set up the current date to appear in the footer, that's simple.
I'm looking for something like the quot;Insert Fieldquot; 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
www.rondebruin.nl/print.htm#Saved

--
Regards Ron de Bruin
www.rondebruin.nlquot;Youngergirl44quot; gt; wrote in message
...
gt;I know how to set up the current date to appear in the footer, that's simple.
gt; I'm looking for something like the quot;Insert Fieldquot; command in Word 2003 -
gt; where the date that appears is the creation, last saved or last printed date,
gt; not the current date. Is this possible?
View Menu
Header and Footer
Custom Footer..... date, day file name, whatever.

S.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?quot;Ron de Bruinquot; wrote:

gt; You must use code to do this
gt;
gt; See this page for a example
gt; www.rondebruin.nl/print.htm#Saved
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Youngergirl44quot; gt; wrote in message
gt; ...
gt; gt;I know how to set up the current date to appear in the footer, that's simple.
gt; gt; I'm looking for something like the quot;Insert Fieldquot; command in Word 2003 -
gt; gt; where the date that appears is the creation, last saved or last printed date,
gt; gt; not the current date. Is this possible?
gt;
gt;
gt;

Highlight this word quot;BuiltinDocumentPropertiesquot; in the VBA editor and press F1

you see the that you can use quot;Creation Datequot;

See also
www.cpearson.com/excel/docprop.htm
--
Regards Ron de Bruin
www.rondebruin.nlquot;Youngergirl44quot; gt; wrote in message
news
gt; This looks like it should do the trick... I'm not familliar with the code
gt; side of Excel. How could I change your example to show a creation date
gt; instead of a last saved date?
gt;
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; You must use code to do this
gt;gt;
gt;gt; See this page for a example
gt;gt; www.rondebruin.nl/print.htm#Saved
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;Youngergirl44quot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I know how to set up the current date to appear in the footer, that's simple.
gt;gt; gt; I'm looking for something like the quot;Insert Fieldquot; command in Word 2003 -
gt;gt; gt; where the date that appears is the creation, last saved or last printed date,
gt;gt; gt; not the current date. Is this possible?
gt;gt;
gt;gt;
gt;gt;
That's it! Thanks for your help!

quot;Ron de Bruinquot; wrote:

gt; Highlight this word quot;BuiltinDocumentPropertiesquot; in the VBA editor and press F1
gt;
gt; you see the that you can use quot;Creation Datequot;
gt;
gt; See also
gt; www.cpearson.com/excel/docprop.htm
gt;
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Youngergirl44quot; gt; wrote in message
gt; news
gt; gt; This looks like it should do the trick... I'm not familliar with the code
gt; gt; side of Excel. How could I change your example to show a creation date
gt; gt; instead of a last saved date?
gt; gt;
gt; gt;
gt; gt; quot;Ron de Bruinquot; wrote:
gt; gt;
gt; gt;gt; You must use code to do this
gt; gt;gt;
gt; gt;gt; See this page for a example
gt; gt;gt; www.rondebruin.nl/print.htm#Saved
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards Ron de Bruin
gt; gt;gt; www.rondebruin.nl
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Youngergirl44quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I know how to set up the current date to appear in the footer, that's simple.
gt; gt;gt; gt; I'm looking for something like the quot;Insert Fieldquot; command in Word 2003 -
gt; gt;gt; gt; where the date that appears is the creation, last saved or last printed date,
gt; gt;gt; gt; not the current date. Is this possible?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;