Is there anyway to set Excel to automatically add header or footer info to every workbook created eg Path, date, filename. I basically just want to force this rather than trying to get users to remember to add this.
Start Excel with a blank workbook
Set up the header/footer info like you want
Do a SaveAs
In the "Save as type" pull-down, select Template (*.xlt)
In the "Save in" box at the top, navigate to C:\Program Files\Microsoft Office\Office10\XLStart
(note: I'm using Excel 2002, your path may differ, but you are looking for the XLStart directory)
Save the template with file name of Book.xlt
The next time you start Excel it will automatically have the header/footer info.
Tip: If one already exists, rename the original Book.xlt to something else so you can return to the default if desired.