Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access MS property "lastsavedby" for a file
Does anyone know how to get the name of the user who last saved a fil
on a server using Excel VB ? It may be someting along the lines of: Dim fs, f1, fc Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.GetFolder(folderspec) Set fc = f.Files nfiles = 0 For Each f1 In fc nfiles = nfiles + 1 fnames(nfiles) = f1.Name owner(nfiles) = f1.lastsavedby Next which of course does not work -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access MS property "lastsavedby" for a file
"jmoffat " wrote in message ... Does anyone know how to get the name of the user who last saved a file on a server using Excel VB ? Use Workbook.BuiltinDocumentProperties - it has a Last Author item. You can find how to access it in the help file. .... unless you mean a non-excel file, in which case I don't think you can. Iain King |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Excel Discussion (Misc queries) | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Setting up and Configuration of Excel | |||
Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
"Path/File Access Error" on Sheets.Copy | Excel Programming |