Previous date in workbook
Closed
abhi
-
1 Mar 2010 à 04:20
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Mar 2010 à 08:18
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Mar 2010 à 08:18
Related:
- Previous date in workbook
- Restore previous version of excel file - Guide
- How to see previous downloads on safari - Guide
- How to copy macro from one workbook to another - Guide
- Previous sites visited - Guide
- Vb net add sheet to excel workbook - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
1 Mar 2010 à 08:18
1 Mar 2010 à 08:18
Are you looking for last modified date or one date even earlier than that (last, last modified date). Properties can only give you creation and last modified time and not a time in between
for last modified date : property name is Last Save Time
for creation date: property name is Creation Date
you can call the function in your sheet as
=getDocProp("Last Save Time") for last modified time
and
=getDocProp("Creation Date ") for creation time
Public Function getDocProp(propName As String)
On Error GoTo ERR_HNDL
GetDocProp = ActiveWorkbook.BuiltinDocumentProperties(propName)
Exit Function
ERR_HNDL:
GetDocProp = "Error"
Exit Function
End Function
for last modified date : property name is Last Save Time
for creation date: property name is Creation Date
you can call the function in your sheet as
=getDocProp("Last Save Time") for last modified time
and
=getDocProp("Creation Date ") for creation time
