Insert the date an Excel Workbook was last modified.

please someone explain step by step what should an average excel user should do to get this VB works properly. it is not enough to just write a code and then assume that others have the same ability, and experiences that you as an expert have.

please consider that some people have never used VB in excel.

I personally have experienced some major problems with files containing VB codes so I prefer not use it.

I have just spent over 20 minutes trying to add this simple reference into my spreadsheet and give up!. Is there any feedback from Microsoft stating that they will provide an update to make this field a user friendly addition?

>>>

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.

I am also looking for a way to insert a date and couldn't find one, but saw this string.  I want to say thank you for your views.  I agree that it is "non-simple."  Sometimes we forget others don't have the knowledge or training or experience in compters, or programming, or being a doctor, etc... It's nice to know there are others who understand this.  Thank you.