Saving Excel templates

  • Thread starter Newman Emanouel
  • Start date
N

Newman Emanouel

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
 
Top