Hi All,

I need to add the 'date last modified' of one spreadsheet into a cell of
another spreadsheet and have it update whenever the spreadsheet is opened.

i.e. in cell A1 of spreadsheet B, i would like to show the date last
modified of spreadsheet A and whenever spreadsheet B is opened it updates so
that if spreadsheet A has been modified, the date updates.

I cannot change spreadsheet A in any way.

If possible i'd like to do this with formulae but if the only solution is in
VBA, please can you be as specific as possible as my vba is weak.

Thanks
Emma