last updated

[Ruth]

Would like to have the spreadsheet automatically put in
last time it was updated, so that it will only be modified
when a change has been made to the worksheet, but always
show up on the worksheet.
Worksheet does not contain any calculations, or functions
in it.

 

[Frank Kabel]

Hi
one way:
you may use the following UDF (put it in a module of your workbook):
Public Function last_created(filename As String) As Date
Dim oFS As New Scripting.FileSystemObject
Dim oFL As Scripting.File
Set oFL = oFS.GetFile(filename)
last_created = oFL.DateLastModified
End Function

Put the following formula in one of your cells:
=last_created("your_filename+path")
will return the last saved date

 

[Bill Ridgeway]

I replied to a similar (was it your) query recently.

Enter in the cell either =NOW() (if you want date and time) or TODAY() (if
you want just date)
Format the cell <Custom> "Last updated " dd/mm/yyyy

I know that works because I use it!
--

Regards.

Bill Ridgeway
Computer Solutions

 

[Guest]

Hi Bill,

Thanks that worked, I really appreciate your assistance!

Ruth

 

[neowok]

surely that merely displays the 'current' date in the box, not the dat
the file was last modified.

i think it was my query you responded to with that and ive just no
realised that its almost certainly simply listing todays date instea
of the last modified date