last updated

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.
 
F

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
 
G

Guest

Hi Frank,
Thanks for the information,When you put the formula in a
cell that does not work, any other suggestions?
 
B

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
 
N

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
 
Top