"Last saved" information

G

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.
 
F

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)
 
G

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.
 
G

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.
 
G

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.
 
Top