| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I insert "last saved date" in as a field in excel?
I'm trying to enter into excel (probably in the footer) the field "last saved
date" but can't seem to find the formula or the field. In word, I think the function is "savedate". Does anyone know the answer to this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I insert "last saved date" in as a field in excel?
hi chirag
Not so easy in Excel See http://www.rondebruin.nl/print.htm#Saved -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... I'm trying to enter into excel (probably in the footer) the field "last saved date" but can't seem to find the formula or the field. In word, I think the function is "savedate". Does anyone know the answer to this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I insert "last saved date" in as a field in excel?
Thanks Ron de Bruin,
I tried that but it didn't seem to print the last saved date for me. Is there something I'm supposed to specifically do to invoke that private sub? "Ron de Bruin" wrote: hi chirag Not so easy in Excel See http://www.rondebruin.nl/print.htm#Saved -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... I'm trying to enter into excel (probably in the footer) the field "last saved date" but can't seem to find the formula or the field. In word, I think the function is "savedate". Does anyone know the answer to this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I insert "last saved date" in as a field in excel?
Hi chirag
When you print it will add it in the Footer Have you copy it in the Thisworkbook module of the workbook ? Right click on the Excel icon next to File in the Worksheet menu bar Choose view code Paste this event there Alt-q to go back to Excel Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In ThisWorkbook.Worksheets wkSht.PageSetup.RightFooter = "&8Last Saved : " & _ Format(ThisWorkbook.BuiltinDocumentProperties("Las t Save Time"), _ "yyyy-mmm-dd hh:mm:ss") Next wkShtEnd Sub -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... Thanks Ron de Bruin, I tried that but it didn't seem to print the last saved date for me. Is there something I'm supposed to specifically do to invoke that private sub? "Ron de Bruin" wrote: hi chirag Not so easy in Excel See http://www.rondebruin.nl/print.htm#Saved -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... I'm trying to enter into excel (probably in the footer) the field "last saved date" but can't seem to find the formula or the field. In word, I think the function is "savedate". Does anyone know the answer to this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I insert "last saved date" in as a field in excel?
Many thanks for your replies, Ron.
Ok, so it works when I add it to Thisworkbook, but not the personal.xls module. I was hoping that I could do this via a macro on every spreadsheet I open up. I wasn't successful at getting my macro to work, and doing this step manually for every workbook doesn't seem to be the most efficient solution. Any other ideas? "Ron de Bruin" wrote: Hi chirag When you print it will add it in the Footer Have you copy it in the Thisworkbook module of the workbook ? Right click on the Excel icon next to File in the Worksheet menu bar Choose view code Paste this event there Alt-q to go back to Excel Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In ThisWorkbook.Worksheets wkSht.PageSetup.RightFooter = "&8Last Saved : " & _ Format(ThisWorkbook.BuiltinDocumentProperties("Las t Save Time"), _ "yyyy-mmm-dd hh:mm:ss") Next wkShtEnd Sub -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... Thanks Ron de Bruin, I tried that but it didn't seem to print the last saved date for me. Is there something I'm supposed to specifically do to invoke that private sub? "Ron de Bruin" wrote: hi chirag Not so easy in Excel See http://www.rondebruin.nl/print.htm#Saved -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... I'm trying to enter into excel (probably in the footer) the field "last saved date" but can't seem to find the formula or the field. In word, I think the function is "savedate". Does anyone know the answer to this? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I insert "last saved date" in as a field in excel?
Hi chirag
See http://www.cpearson.com/excel/AppEvent.htm I not use this myself but maybe anybody else can you help you with this -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... Many thanks for your replies, Ron. Ok, so it works when I add it to Thisworkbook, but not the personal.xls module. I was hoping that I could do this via a macro on every spreadsheet I open up. I wasn't successful at getting my macro to work, and doing this step manually for every workbook doesn't seem to be the most efficient solution. Any other ideas? "Ron de Bruin" wrote: Hi chirag When you print it will add it in the Footer Have you copy it in the Thisworkbook module of the workbook ? Right click on the Excel icon next to File in the Worksheet menu bar Choose view code Paste this event there Alt-q to go back to Excel Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In ThisWorkbook.Worksheets wkSht.PageSetup.RightFooter = "&8Last Saved : " & _ Format(ThisWorkbook.BuiltinDocumentProperties("Las t Save Time"), _ "yyyy-mmm-dd hh:mm:ss") Next wkShtEnd Sub -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... Thanks Ron de Bruin, I tried that but it didn't seem to print the last saved date for me. Is there something I'm supposed to specifically do to invoke that private sub? "Ron de Bruin" wrote: hi chirag Not so easy in Excel See http://www.rondebruin.nl/print.htm#Saved -- Regards Ron de Bruin http://www.rondebruin.nl "chirag" wrote in message ... I'm trying to enter into excel (probably in the footer) the field "last saved date" but can't seem to find the formula or the field. In word, I think the function is "savedate". Does anyone know the answer to this? |
| 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 | |||
| Can you insert a vertical scrolling field in excel? Not a drop dow | Excel Worksheet Functions | |||
| How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
| How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Worksheet Functions | |||
Linear Mode
