Saving Documents from templates to specific places

  • Thread starter Thread starter Linds
  • Start date Start date
L

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
 
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
 
Back
Top