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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import File Information 0
using two cell references to make up the save as file name 3
Save filename plus last month's date 2
Prompt for Save Path - Use Cell Content for File Name 1
Suggest a file name OnSave 2
How date stamp & save filename? 2
Save Workbook As macro problem 5
File not saving 3

Top