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