LAST SAVED BY

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???
 
D

David McRitchie

ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
in a macro not available in Excel itself.
 
D

David McRitchie

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

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

David McRitchie said:
ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
in a macro not available in Excel itself.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Krycek said:
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???
Click to expand...
Click to expand...
 
Top