User Tools

Site Tools


microsoft:office:scripting:vba:excel

Microsoft - Office - Scripting - VBA - Excel

Snippets

Display Last Saved Date on worksheet

Insert VBA module with code:

Function LastSavedTimeStamp() As Date
  LastSavedTimeStamp = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function

Formula for cell:

=LastSavedTimeStamp()

Source: Richard.Gale on stackoverflow - Display Last Saved Date on worksheet

microsoft/office/scripting/vba/excel.txt · Last modified: 2016/06/03 15:40 by bas

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki