Last Update

[Karen]

Is there a way I can tell when the last update was for a
particular spreadsheet without having an established cell
specifically for an update date?

Thanks for any help

Karen

 

[John Wilson]

Karen,

One way would be with a macro.
Press Alt + F11
Right click on "ThisWorkbook"
Select Insert/Module
In the module window on the right, copy and paste the following:

Sub SavedDate()
MsgBox = thisworkbook.builtindocumentproperties("Last Save Time")
End Sub

Now you can run the macro at any time.
Tools/Macro/Macros..select this macro and then "Run"

John

 

[Norman Harker]

Hi Karen!

Excel doesn't maintain a date of a last change to a workbook.

There is the following UDF that can be used with the function deleted
after use.

Public Function LASTSAVED()
LASTSAVED =
Application.Caller.Parent.Parent.BuiltinProperties("Last Save Time")
End Function

Or you can use Explorer to find the time a file was last modified
(i.e. Saved)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ron de Bruin]

Hi Karen

You have got two answers for Excel 2000 and higher but
This is not working correct in Excel 97

Read this from Tom Ogilvy

Note that this property is not maintained in xl97. However, if the workbook
is created/used in both xl97 and later versions, then when used in the
later versions and saved the property is maintained but when used in xl97
and saved, the property is not altered. The time it was last saved in the
later version will be retrieved if this property is called. If created and
used exclusively in xl97, calling this property will raise an error. You
can use the beforesave event to update this property in xl97 as a
workaround. Just test the version of excel and if xl97, update the
property.