"Last saved" information

[Gustavo Strabeli]

Hi!
Does anyone know a VB code which can return me the name of the user who last
saved the worksheet?

Thanks,
Gustavo.

 

[Frank Kabel]

Hi
use the following UDF:

Function DocProps(prop As String)
application.volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

and enter in a cell
=DOCPROPS("last author")
(format cell as date)

 

[Gustavo Strabeli]

Thanks, Frank!
One question: what's a UDF?

Rgds,
Gustavo

 

[Frank Kabel]

Hi Gustavo
a UDF is a 'User Defined Function'. That is a function written in VBA.
For more see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Gustavo Strabeli]

Thanks once again!
Gustavo.

Hi Gustavo
a UDF is a 'User Defined Function'. That is a function written in VBA.
For more see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Gustavo Strabeli]

Frank,
The UDF below worked as a charm, however I'm facing a problem:
If a have another excel file opened, the current sheet (where I've inserted
the UDF) shows me the last saved author from the other sheet...how can that
be solved? Any clue?

Thanks.

 

[Gustavo Strabeli]

Frank,
The UDF below worked as a charm, however I'm facing a problem:
If a have another excel file opened, the current sheet (where I've inserted
the UDF) shows me the last saved author from the other sheet...how can that
be solved? Any clue?

Thanks.

 

[Gustavo Strabeli]

Frank,
The UDF below worked as a charm, however I'm facing a problem:
If a have another excel file opened, the current sheet (where I've inserted
the UDF) shows me the last saved author from the other sheet...how can that
be solved? Any clue?

Thanks.