LAST SAVED BY

  • Thread starter Thread starter Krycek
  • Start date Start date
K

Krycek

How would I be able to get the Last Saved By field code
for Excel.

I can do it for Word, very easily in fact. In a
header/footer I can choose to display Last Saved By info.

Why does this seem impossible to do in Excel???
 
ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
in a macro not available in Excel itself.
 
Sorry misread, you wanted the author.

You can substitute Author is what I gave you, or
you can use Application.UserName this User Defined Function instead.

Function USRNameF()
USRNameF = Application.UserName
End Function

=USRNameF()

You will find the name in the File, Properties.

More information in
http://www.mvps.org/dmcritchie/excel/property.htm
 
Back
Top