Previous date in workbook
Closed
abhi
-
Mar 1, 2010 at 04:20 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 1, 2010 at 08:18 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 1, 2010 at 08:18 AM
Related:
- Previous date in workbook
- How to see previous downloads on safari - Guide
- Run macro on opening workbook - Guide
- Vba create new workbook ✓ - Excel Forum
- No previous version of windows nt can be found on your computer ✓ - Windows XP Forum
- Excel vba add sheet to another workbook - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 1, 2010 at 08:18 AM
Mar 1, 2010 at 08:18 AM
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
