last updated

  • Thread starter Thread starter Ruth
  • Start date Start date
R

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.
 
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
 
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
 
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
 
Back
Top