Save Date

T

tomen24

Any way the spreadsheet can display the last save date time of the spreadsheet?
 
J

Jacob Skaria

Set the Security level to low/medium in (Tools|Macro|Security). From workbook
launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the
below function.Get back to workbook..

Function DocProperty(strQ As String)
Application.Volatile
DocProperty = ActiveWorkbook.BuiltinDocument­Properties (strQ)
End Function

For a already saved workbook enter the formula in any cell..
=DocProperty("last save time")

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to display the last file save date in an excel spreadsheet 3
SAVE AS CSV, KEEP DATE FORMAT 2
"save as" 0
Formula updates with SAVE AS 1
Stop Macro running when I save the workbook 1
Sumproduct Help! 2
permanent conversion of 1904 date format to 1900 date format 3
Comparison of columns using Conditional Formatting 3

Top