Saving filename and file save date?

  • Thread starter Thread starter BobC
  • Start date Start 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
 
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
 
Back
Top