How to automate footers (filename/date) for all new spreadsheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like be able to automatically generate a footer on every spreadsheet
notebook that would contain the filename and date of generation similar to
the capability provided in WordPerfect's QuattroPro.
 
Vasant's response is how to do it for one. But ambdg26 wants to
automate it for ALL. You need to create a template and store it in
your XLStart folder. It is then supposed to open every time you open
Excel and that becomes your default worksheet (including footer).
Follow Vasant's method, then do FILE / SAVE AS, select "Template"
(.xlt) and save it in the XLStart folder.

This is how Excel tells you to do it. I haven't been able to get it
work, however. I have it saved in the XLStart folder but it doesn't
open it like it's supposed to. It's almost like Excel is looking
somewhere else than where I think it is. So I just did a simple macro
to do it for me.
 
Good catch; I missed the partr where the OP wanted to do this for every
workbook.

As for your problem, are you calling the template Book.xlt?
 
No - it was called Book1.xlt. I renamed it to Book.xlt and now i
works. Thanks for the tip. I don't recall seeing that in the Exce
instructions. I should have asked several years ago
 

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

path and filename footer 1
convert cell content to filename 2
tab names are wrong when printing custom footers (using [&tab] ) 1
Put filename in a cell 2
How do I auto generate filename to appear in footer for new docume 1
Formula for Last Saved on outside of Header/Footer 1
Header/Footer Date Format 2
is there a way to format the date in an excel footer eg just year 1

Back
Top