Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone know how to automatically enter the last save date on Excel 2007
without creating a macro? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You need to have a macro or a UDF. Try the below UDF
In any cell type the formula =GetProperties("Last Save Time") Function GetProperties(strType As String) As String GetProperties = ThisWorkbook.BuiltinDocumentProperties(strType) End Function If this post helps click Yes --------------- Jacob Skaria "Fordbfilm" wrote: Does anyone know how to automatically enter the last save date on Excel 2007 without creating a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save Date | Excel Worksheet Functions | |||
Recovering File Info Specifically Save Date or Print Date | Excel Discussion (Misc queries) | |||
Last Save Date | Excel Discussion (Misc queries) | |||
save as future date eg expected delivery date | Excel Discussion (Misc queries) | |||
add a date that changes only when I save the doc. | Excel Worksheet Functions |