Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer : Last saved date
Problem : I have xlt template. When a user opens by double clicking the
template it creates xls. What i want is that if xls is not yet saved then footer should print todays date and time. but if xls is saved and being accessed later then it should print the last saved time. What i did : on workbook_beforeprint i wrote the following :- Application.Volatile ActiveSheet.PageSetup.LeftFooter=_ ThisWorkbook.BuiltinDocumentProperties("Last Save Date") It works fine if the xls has been saved once but if it is not yet saved then it prints the last saved date of the template and not the xls created. -- Ajit |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer : Last saved date
Hi
no chance around this restriction. You have to save first before this document property is updated. what other date would you expect anyway :-)) -- Regards Frank Kabel Frankfurt, Germany "Ajit" schrieb im Newsbeitrag ... Problem : I have xlt template. When a user opens by double clicking the template it creates xls. What i want is that if xls is not yet saved then footer should print todays date and time. but if xls is saved and being accessed later then it should print the last saved time. What i did : on workbook_beforeprint i wrote the following :- Application.Volatile ActiveSheet.PageSetup.LeftFooter=_ ThisWorkbook.BuiltinDocumentProperties("Last Save Date") It works fine if the xls has been saved once but if it is not yet saved then it prints the last saved date of the template and not the xls created. -- Ajit |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer : Last saved date
Hi Ajit
You can use this If the file is not saved it have no path If Len(ThisWorkbook.Path) = 0 then ....... Else ....... End if -- Regards Ron de Bruin http://www.rondebruin.nl "Ajit" wrote in message ... Problem : I have xlt template. When a user opens by double clicking the template it creates xls. What i want is that if xls is not yet saved then footer should print todays date and time. but if xls is saved and being accessed later then it should print the last saved time. What i did : on workbook_beforeprint i wrote the following :- Application.Volatile ActiveSheet.PageSetup.LeftFooter=_ ThisWorkbook.BuiltinDocumentProperties("Last Save Date") It works fine if the xls has been saved once but if it is not yet saved then it prints the last saved date of the template and not the xls created. -- Ajit |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer : Last saved date
I would expect today's date if not saved (and not the last template saved
date). "Frank Kabel" wrote: Hi no chance around this restriction. You have to save first before this document property is updated. what other date would you expect anyway :-)) -- Regards Frank Kabel Frankfurt, Germany "Ajit" schrieb im Newsbeitrag ... Problem : I have xlt template. When a user opens by double clicking the template it creates xls. What i want is that if xls is not yet saved then footer should print todays date and time. but if xls is saved and being accessed later then it should print the last saved time. What i did : on workbook_beforeprint i wrote the following :- Application.Volatile ActiveSheet.PageSetup.LeftFooter=_ ThisWorkbook.BuiltinDocumentProperties("Last Save Date") It works fine if the xls has been saved once but if it is not yet saved then it prints the last saved date of the template and not the xls created. -- Ajit |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer : Last saved date
Hi
but as this is not a 'saved date' this would be 'wrong' :-) You may use Ron's suggestion to check for a non-saved workbook and use then the current date -- Regards Frank Kabel Frankfurt, Germany "Ajit" schrieb im Newsbeitrag ... I would expect today's date if not saved (and not the last template saved date). "Frank Kabel" wrote: Hi no chance around this restriction. You have to save first before this document property is updated. what other date would you expect anyway :-)) -- Regards Frank Kabel Frankfurt, Germany "Ajit" schrieb im Newsbeitrag ... Problem : I have xlt template. When a user opens by double clicking the template it creates xls. What i want is that if xls is not yet saved then footer should todays date and time. but if xls is saved and being accessed later then it should print the last saved time. What i did : on workbook_beforeprint i wrote the following :- Application.Volatile ActiveSheet.PageSetup.LeftFooter=_ ThisWorkbook.BuiltinDocumentProperties("Last Save Date") It works fine if the xls has been saved once but if it is not yet saved then it prints the last saved date of the template and not the xls created. -- Ajit |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer : Last saved date
Thanks Ron,
It worked perfect. Good Logic. Thanx, Ajit "Ron de Bruin" wrote: Hi Ajit You can use this If the file is not saved it have no path If Len(ThisWorkbook.Path) = 0 then ....... Else ....... End if -- Regards Ron de Bruin http://www.rondebruin.nl "Ajit" wrote in message ... Problem : I have xlt template. When a user opens by double clicking the template it creates xls. What i want is that if xls is not yet saved then footer should print todays date and time. but if xls is saved and being accessed later then it should print the last saved time. What i did : on workbook_beforeprint i wrote the following :- Application.Volatile ActiveSheet.PageSetup.LeftFooter=_ ThisWorkbook.BuiltinDocumentProperties("Last Save Date") It works fine if the xls has been saved once but if it is not yet saved then it prints the last saved date of the template and not the xls created. -- Ajit |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer : Last saved date
Yes you are right, Ron's suggestion worked perfect.
Thanks you very much for chipping in your views. Thumbs up! "Frank Kabel" wrote: Hi but as this is not a 'saved date' this would be 'wrong' :-) You may use Ron's suggestion to check for a non-saved workbook and use then the current date -- Regards Frank Kabel Frankfurt, Germany "Ajit" schrieb im Newsbeitrag ... I would expect today's date if not saved (and not the last template saved date). "Frank Kabel" wrote: Hi no chance around this restriction. You have to save first before this document property is updated. what other date would you expect anyway :-)) -- Regards Frank Kabel Frankfurt, Germany "Ajit" schrieb im Newsbeitrag ... Problem : I have xlt template. When a user opens by double clicking the template it creates xls. What i want is that if xls is not yet saved then footer should todays date and time. but if xls is saved and being accessed later then it should print the last saved time. What i did : on workbook_beforeprint i wrote the following :- Application.Volatile ActiveSheet.PageSetup.LeftFooter=_ ThisWorkbook.BuiltinDocumentProperties("Last Save Date") It works fine if the xls has been saved once but if it is not yet saved then it prints the last saved date of the template and not the xls created. -- Ajit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I capture the last date a file was saved in the footer | Excel Discussion (Misc queries) | |||
Last saved date in footer | Excel Discussion (Misc queries) | |||
Last Saved Date in Footer (right aligned) | Excel Discussion (Misc queries) | |||
Excel "Last Saved" in Footer | Excel Discussion (Misc queries) | |||
How to insert date last saved into the sheet (not the footer) | Excel Worksheet Functions |