software

I would like to have a formula in excel that checkes quot;date modifiedquot; of the
file and shows this in a cell, so a user opening a file can see when the file
was last saved/modified. I saw this when using SAP Business Warehouse tool
but it was probably part of the program. Is there a possibility to to
something like this with a normal excel file?

heh, found it myself later:

for others - use this macro:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count gt; 1 Then Exit Sub
If Not Intersect(Range(quot;A2:A10quot;), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = quot;dd mmm yyyy hh:mm:ssquot;
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub

Found on www.mcgimpsey.com/excel/timestamp.html.Hi

Copy this UDF into your workbook's module

Public Function LastModified(Optional parTime As Date)
LastModified = ThisWorkbook.BuiltinDocumentProperties(12)
End FunctionNow, you can enter into any cell of workbook the formula
=LastModified()
or, when you want to get the formula volatile
=LastModified(TODAY())
or
LastModified(NOW())
Format the cell with formula in any valid date(time) format.

--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;TMarkquot; gt; wrote in message
...
gt;I would like to have a formula in excel that checkes quot;date modifiedquot; of the
gt; file and shows this in a cell, so a user opening a file can see when the
gt; file
gt; was last saved/modified. I saw this when using SAP Business Warehouse tool
gt; but it was probably part of the program. Is there a possibility to to
gt; something like this with a normal excel file?