Saving Documents from templates to specific places

[Linds]

hello I am wandering: I have made a template from Excel
that I use frequently, I want to save every document
made from that template to a specific place and NOT the
same place as the default excel template. Is it possible
for a template to have its own default "save as" location?
thanks linds

 

[steve]

Linds,

You might look into the before save event found in the ThisWorkbook
module.
I'm not sure how to code it. But you might start with
Cancel = True
to stop the save
than add code to do a save as and specify the path and name.

But be careful because this will prevent you from working on the template
and resaving it as a template unless you turn events off.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
* your code here *
End Sub