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

"BobC" wrote:

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