Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding name of last user who modified Excel Spreadsheet
IS there code to find the name or userid of the last user who modified a
particular excel spreadsheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding name of last user who modified Excel Spreadsheet
Hi
use the following UDF: Function DocProps(prop As String) application.volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties _ (prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function and enter in a cell =DOCPROPS("last author") or =DOCPROPS("last save time") -----Original Message----- IS there code to find the name or userid of the last user who modified a particular excel spreadsheet? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding name of last user who modified Excel Spreadsheet
You could try using
ActiveWorkbook.BuiltinDocumentProperties("Last _ Author").value to find this, although this may depend upon the individuals updating the User name in Excel Options. HTH Simon Livings *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change tooltips for user-modified colors? | Excel Discussion (Misc queries) | |||
Date modified within Spreadsheet | Excel Discussion (Misc queries) | |||
Alert user that row has been modified by changing row color | Excel Worksheet Functions | |||
Need to insert file modified date of Excel spreadsheet in a cell | Excel Discussion (Misc queries) | |||
HELP - How do I know if a spreadsheet has been modified | Excel Programming |