Saving filename and file save date?

B

BobC

How do I save the file name/path and the last file save date as part of
the Header or Footer of a spreadsheet?

Bob
 
J

Joel

I got the code below by recording a mqcro and then adding a header to the
worksheet

With ActiveSheet.PageSetup
.LeftHeader = "&Z&F"
.CenterHeader = "&D&T"
End With
 
Top