I am some what confused by this. Do you want the date of the workbook when
you open it stored somewhere? If so, you can use this function


'-----------------------------------------------------------------
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 get the value like so

msgbox DocProps ("last save time")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"vmadan16" wrote in message
...
Hello All,

I want to retrive the last modified time and date of another workbook. and

I have a update button in my workbook(Admin workbook). user will update
the
data in the User Workbook, that data is referred to the Admin Workbook.
Calculations are done in Admin Workbook the final result will be referred
back to User Workbook. This should be done if I click that button which is
in
Admin sheet and without any popup messages when the user pens the workbook
for updating the data in the fields.

Please help me out with this.

It will be very greatful.

thanks in Advance.