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