How to access MS property "lastsavedby" for a file

J

jmoffat

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
 
I

Iain King

jmoffat > said:
Does anyone know how to get the name of the user who last saved a file
on a server using Excel VB ?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate combobox with folder names 6
Pause a loop after 100 cycles 7
Creating a list of Subfolders and sizes 8
Failed to add footer one of work sheet, Thanks 3
Log-In Credentials in a Macro 1
Edit VBA to print Directory including file owner into Excel Spread 8
File Properties 2
Using Application.FileDialog(msoFileDialogFolderPicker) 1

Top