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

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


"Youngergirl44" <[email protected]> wrote in message
news:[email protected]...
>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?

[[email protected]]

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" 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" <[email protected]> wrote in message
> news:[email protected]...
> >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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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?
>>
>>
>>

[Youngergirl44]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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?
> >>
> >>
> >>
>
>
>