you dont need a macro, just embed the cell with the date from the other file as a formula.
=filename!a2