Saving different Docs on different locations

S

Spiridon

I have two documents as a template which I want to save on different
locations
For example Book1 template I want to save always on location
D:/xxx/yyyy
and Book2 template always on location E:/xxx/yyy
Has anybody have an idea how can I solve this problem?
Thanks in advance
 
D

Dave Peterson

How about this?

Instead of using real templates (*.xlt), use a normal workbook (*.xls). But
either mark it readonly in windows explorer. Store them each in their proper
homes.

Then when the users save the file, they'll see a File|SaveAs dialog, but the
folder will be the location of the original file.
 
Top