Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last modified user
Does anyone know how I can return the user name who last modified a file via
VB codes in a spreadsheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last modified user
'-----------------------------------------------------------------
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 use MsgBox DocProps("last author") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "linglc" wrote in message ... Does anyone know how I can return the user name who last modified a file via VB codes in a spreadsheet? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last modified user
Hi Bob,
I need something like this -- the "Last Modified By" or "Last Author" value -- but for a given file in a folder without opening it in Excel, and regardless of what kind of file it is. The FileSystemObject doesn't seem to support this, crazy as it seems. I've checked the properties of the File object in Excel VBA Help and it doesn't seem to have anything that matches this. I've bound the MS Scripting Runtime reference and tried: LastModBy = FileItem.LastModified LastModBy = FileItem.LastModifiedBy LastModBy = FileItem.ModifiedBy LastModBy = FileItem.Modified LastModBy = FileItem.LastAuthor LastModBy = FileItem.Author All of them fail as soon as I try to step through. -- Gregg Roberts "Bob Phillips" wrote: '----------------------------------------------------------------- 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 use MsgBox DocProps("last author") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "linglc" wrote in message ... Does anyone know how I can return the user name who last modified a file via VB codes in a spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change tooltips for user-modified colors? | Excel Discussion (Misc queries) | |||
Alert user that row has been modified by changing row color | Excel Worksheet Functions | |||
Do not let user save template if it has been been modified | Excel Programming | |||
Log User Name and Date when userform was run/modified | Excel Programming | |||
Finding name of last user who modified Excel Spreadsheet | Excel Programming |