Insert the date an Excel Workbook was last modified.

Hello, the macro works but the date is wrong (2006 instead 2013) .

what could be the reason?

tks

I had the same problem, but Dave_A_NM actually sketched a solution above. The macro has to be in a module and a quick way of creating a module is like this:

Start the macro recorder and stop it again

ALT+F11

In the left column of the visual basic window find Modules with Module 1

Double Click on Module 1

Delete the newly created Macro1 () in the text field to the right

Insert the LastSaveDate() macro text in stead

My macro is a little different, but it works:

Private Function LastSave()

    Application.Volatile

    LastSave = ThisWorkbook.BuiltinDocumentProperties("Last Save Time").Value

' In a cell enter: =lastsave()

' This macro must be stored in a module; not in a sheet

End Function

Now I only need to find out how to define the correct format, when entering this

="Last saved: "&lastsave()

but that is a smal problem

>>>

As far as I know, the only way to get the saved date is via some non-simple vba macro that must be inserted into your worksheet

<<<

 

It isn't "non-simple" at all. It is quite simple, just two lines of code.

 

 

Function LastSaveDate()

    Application.Volatile True

    LastSaveDate = FileDateTime(ThisWorkbook.FullName)

End Function

 

You can call this from a cell with

=LastSaveDate()

 

That's your perspective as an MVP and VBA expert (and probably other programming languages too). The average user like me does not want to write a line of code to use a very basic function for many reasons especially when that function has existed in other parts of Microsoft office for many, many years. Is it so hard for the same product team in the same company to share the code and get basic functionality consistent among the sub-products?

 

Besides, you are also ignoring another major issue which is our deployment of excel disables macros by default. While this may be trivial to you technically ("just" 2-lines of code as you put it), will still require the same painful, lengthy approval process to get through the IT department.

 

Try to consider the perspective of the average excel user who has little control over the software installed on her computer and really doesn't know even where to start writing a macro program.

Well - I have to second this sentiment. I am a Program Manager that would find it very helpful to know when my task sheets were last saved. I am not "into programming", although I do not mind dabbling with macros and other Excel functions. I have spent the last hour trying to figure out VBA ..... simply to add a date to a spreadsheet. 

The comment above "It isn't non-simple at all. It is quite simple, just two lines of code" borders on being condescending. It is comparable to saying "making a million dollars isn't non-simple at all. It is quite simple, just earn it".

This is like driving a tack with a sledgehammer.

Where are you putting the code? Do not put it in the ThisWorkbook module or in one of the sheet modules. It needs to go into a regular code module. In VBA, go to the Insert menu and choose "Module". This will insert a new code module named Module1 into your project. Put the code in that module.