Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I make a formula in Excel showing when the file modified?
I would like to have a formula in excel that checkes "date modified" 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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I make a formula in Excel showing when the file modified?
heh, found it myself later:
for others - use this macro: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Count 1 Then Exit Sub If Not Intersect(Range("A2:A10"), .Cells) Is Nothing Then Application.EnableEvents = False If IsEmpty(.Value) Then .Offset(0, 1).ClearContents Else With .Offset(0, 1) .NumberFormat = "dd mmm yyyy hh:mm:ss" .Value = Now End With End If Application.EnableEvents = True End If End With End Sub Found on http://www.mcgimpsey.com/excel/timestamp.html. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I make a formula in Excel showing when the file modified?
Hi
Copy this UDF into your workbook's module Public Function LastModified(Optional parTime As Date) LastModified = ThisWorkbook.BuiltinDocumentProperties(12) End Function Now, 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.laanemets<attarkon.ee ) "TMark" wrote in message ... I would like to have a formula in excel that checkes "date modified" 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add the file last modified date into an Excel header? | Excel Discussion (Misc queries) | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
external database file into excel formula | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |