Sorry - I am at a loss with this one
"JLGWhiz" wrote:
You enter it into a worksheet by making a variable equal to the return value
of the built in properties:
userName = ThisWorkbook.BuiltInDocumentProperties("Author").V alue
ActiveSheet.ActiveCell = userName
"JohnUK" wrote:
Many thanks Chip, but I am not sure how I would enter that into a code so
that it would paste those values into the cells of a worksheet.
John
"Chip Pearson" wrote:
You can get the name of the file with
ThisWorkbook.Name 'or
ThisWorkbook.FullName.
You can get the original author of the file with
ThisWorkbook.BuiltInDocumentProperties("Author").V alue
You can get the last-saved-by user with
ThisWorkbook.BuiltInDocumentProperties("Last Author").Value
These two values return the name that is entered as the "User Name" in
the Options dialog box. This is not the user's logon id.
You can get the last save time with
FileDateTime(ThisWorkbook.FullName)
Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Sat, 29 Nov 2008 09:39:01 -0800, JohnUK
wrote:
Is there a way of entering into cells (below each other)
1. The name of the file
2. Last person who saved the file
3. Last person accessed the file
4. Date and time last saved?
Help greatly appreciated
John