View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Last Updated Excel File

Use the below UDF.If you are new to VBA set the Security level to low/medium
in (Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11.
From menu 'Insert' a module and paste the below function. Save. Get back to
Workbook.

Function GetDocProperty(strKey)
Application.Volatile
GetDocProperty = CStr(ActiveWorkbook.BuiltinDocumentProperties _
(strKey))
End Function

In any cell use the below formula
=GetDocProperty("last author")

If this post helps click Yes
---------------
Jacob Skaria


"meyerryang" wrote:

I know that if you look at the properties you can determine when a
spreadsheet was created it and who created it (username account). Can you
determine the last user who updated it?