Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving Version Control
Hi
I'm looking in to low level version control in Excel (2003), is there a function (or any other option) to display on the worksheet itself the date, time and user name who last saved that file? Any help would be appreciated! Thanks Rob |
#2
|
|||
|
|||
Put this code in a standard code module
'----------------------------------------------------------------- Function DocProps(prop As String) '----------------------------------------------------------------- Application.Volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocument*Properties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell such as =DocProps ("last author") or =DocProps ("last save time") -- HTH RP (remove nothere from the email address if mailing direct) "Rob" wrote in message ... Hi I'm looking in to low level version control in Excel (2003), is there a function (or any other option) to display on the worksheet itself the date, time and user name who last saved that file? Any help would be appreciated! Thanks Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using version control in Excel 2003 | Excel Discussion (Misc queries) | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Preventing other users saving another version of protected workboo | Excel Discussion (Misc queries) | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |