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.