Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to automate footers (filename/date) for all new spreadsheets?
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. |
#2
|
|||
|
|||
File | Page Setup | Header/Footer | Custom Footer.
-- Vasant "amgbd26" wrote in message ... 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. |
#3
|
|||
|
|||
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. -- wmjenner ------------------------------------------------------------------------ wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282 View this thread: http://www.excelforum.com/showthread...hreadid=394378 |
#4
|
|||
|
|||
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? -- Vasant "wmjenner" wrote in message ... 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. -- wmjenner ------------------------------------------------------------------------ wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282 View this thread: http://www.excelforum.com/showthread...hreadid=394378 |
#5
|
|||
|
|||
No - it was called Book1.xlt. I renamed it to Book.xlt and now it works. Thanks for the tip. I don't recall seeing that in the Excel instructions. I should have asked several years ago! -- wmjenner ------------------------------------------------------------------------ wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282 View this thread: http://www.excelforum.com/showthread...hreadid=394378 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automate creation of sheets in excel | Excel Worksheet Functions | |||
How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
How to total items if they fall between a date range | Excel Discussion (Misc queries) | |||
Excel Footers | Excel Discussion (Misc queries) | |||
How can I remove previously used footers from footer selections? | Setting up and Configuration of Excel |