XLstart tempate

[CindyA]

I have made changes to my default template in the XLstart
folder by entering the file name in a footer. I would
like to know how to now apply this to all existing files
that I have, so I don't have to create a footer for all of
my existing files. Thanks,

 

[Ron de Bruin]

Hi CindyA

If you have a Book.xlt in the Xlstart folder all new
workbooks are created from this template.

Not the existing files

Look at this Add-in
AddPath Add-in

http://www.j-walk.com/ss/excel/files/general.htm

 

[Frank Kabel]

Hi
only possible with a macro looping through all your existing files. No
build-in functionality