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? |
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? . |
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! |
All times are GMT +1. The time now is 10:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com