Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto-enter the creation date in footer of an Excel worksh
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto-enter the creation date in footer of an Excel worksh
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto-enter the creation date in footer of an Excel worksh
View Menu
Header and Footer Custom Footer..... date, day file name, whatever. S. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto-enter the creation date in footer of an Excel wo
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel to automatically enter a date | Excel Worksheet Functions | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |