View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default default save directory for a templated worksheet

Please clarify: do you want to save the TEMPLATEs to those directories, or
do you want to save the files CREATED FROM THE TEMPLATES to those directories?

If the latter, you could do it with code imbedded within the template.

"Mike Lang" wrote:

Is there any easy way to automatically have a template save to a particular
location for that template only?

e.g the 'Quotes' template saves to the quote directory
the Orders template saves to the orders directory

Thanks

Mike