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