cwb1014,
When you open a template, you (normally) open a copy of that file, not the
original.
So if you make your required changes to the active file, then save as a
template to the same path/name.xlt, you will have changed the source
template.

Is that what you mean ?

NickHK


"cwb1014" wrote in message
...
Let's say you have a program that generates data that is placed in Excel
files. And let's say you want your program to examine an Excel template,
formatted just the way you want the Excel files that your program outputs
to
look, to determine how to format the files it will output. Can this be
done
and, if so, how?

The idea here is to have the program look at the template each time it
runs
to determine the proper formatting for its output and to allow the user to
change how the program's output will look in future runs of the program
simply by making changes to the template.

Many thanks in advance for any assistance here that anyone can provide.
If
you do post a reply, I'd appreciate your letting me know by email to
that you have done so.