Saving Excel templates
 

Dear All

I have a template which when used to save to a specific folder. For example
I use a standard template to generate a new workbook and I want that workbook
saved to a specific folder different to the normal directory other general
workbooks are filed.

Therefore, when book1.xls is created it would normaly be saved to "My
Documents" what I want is to set in the template that when template1.xls is
created to be saved to "My Documents\New Templates"

Any help in this matter would be very appreciated

Regards

Newman