"Last saved" information

[Gustavo Strabeli]

Hi, Frank!

Another question:

I have 2 sheets in the same workbook.

The function "DOCPROPS" is on sheet2. If someone updates any information on
sheet1 and saves, sheet2 will show this person's name. Any way to change it?

Thanks again.

Gustavo.



-----Original Message-----

From: Frank Kabel [mailto:[email protected]]

Sent: Wednesday, July 28, 2004 3:43 PM

To: Strabeli, Gustavo

Subject: Re: "Last saved" information



Hi

change the function to

Function DocProps(prop As String, rng as range)

application.volatile

On Error GoTo err_value

DocProps = rng.parent.parent.BuiltinDocumentProperties _

(prop)

Exit Function

err_value:

DocProps = CVErr(xlErrValue)

End Function



and in your cell use

=DOCPROPS("last author",A1)

--

Regards

Frank Kabel

Frankfurt, Germany

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