Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to update last save time & last author for each worksheet
Hello. I found code that allows me to display document properties for
a workbook and I am using it to show the last save time and last author as well as other document properties. But I think the code only updates the first worksheet. Would I need to add the code to each worksheet or is there a way to have it update all worksheets simultaneously? Thanks. Here's the code: <code Sub DocumentPropertiesLastModified() Dim a As String Dim b As String Dim c As String Dim d As String 'Worksheets(1).Activate d = ActiveWorkbook.BuiltinDocumentProperties("title") Cells(1, 1).Select ActiveCell.FormulaR1C1 = d a = ActiveWorkbook.BuiltinDocumentProperties("last save time") Cells(2, 5).Select ActiveCell.FormulaR1C1 = "last modified:" & " " & a b = ActiveWorkbook.BuiltinDocumentProperties("Author") Cells(1, 5).Select ActiveCell.FormulaR1C1 = "created by:" & " " & b c = ActiveWorkbook.BuiltinDocumentProperties("Last author") Cells(3, 5).Select ActiveCell.FormulaR1C1 = "last edited by:" & " " & c End Sub </code |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Date, Time Only Upon Save | Excel Discussion (Misc queries) | |||
workbook update each time a new worksheet is selected | New Users to Excel | |||
Update workbook each time a different worksheet is selected | New Users to Excel | |||
save from template to worksheet without update commands | Excel Programming | |||
Time stamping - automated by worksheet update | Excel Programming |