Re: Time Date Last Modified

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Peo and Bob, Thank you both for your responses. Diane

"Bob Phillips" <phillips@xxxxxxxxxxxxx> wrote in message
news:%23l2oRQBUFHA.2172@xxxxxxxxxxxxxxxxxxxxxxx
> Here is an 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
>
> Now you can use the following formula in one of your cells:
> =DocProps("Last save time")
>
> Obviously, the file has to have been saved.
>
> --
>
> HTH
>
> Bob Phillips
>
> "LDL" <diane@xxxxxxxxxxxx> wrote in message
> news:QZWdnUhFq-NtVOrfRVn-ow@xxxxxxxxxxxxxxx
>> I am sharing a worksheet with another person and we both are updating it
>> often throughout the day. I'd like to have a cell display the last time
> and
>> date it was modified. Can this be done? Thanks, Diane
>>
>>
>
>


.

Relevant Pages