Show last saved date and time
To display the last date and time the workbook was saved we need to create a new function in Excel, with the use of VBA, that can then be applied as any other Excel function
Example: Show last saved date and time
Function LastSavedDateTime() As Date
LastSavedDateTime = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function
ADDITIONAL NOTES
Note 1: This VBA code creates a new function that can be used to show the last date and time that the workbook was saved.
Note 1: This VBA code creates a new function that can be used to show the last date and time that the workbook was saved.
|
=LastSavedDateTime()
|
This function was created in VBA, as per the VBA code above, displays the last date and time that the workbook was saved.
Note: for this function to work you must first create the VBA code, as per the VBA example. |