Template Wizard File Save

[Papi]

Normally we would open a Template, fill in data and when saved the Template Wizard add-in will ask if we want to "Create a new record". The diference this time is that we are creating (opening) certain template forms using macros instead of simply opening them. What the program is doing is fine as it saves the files the way we want them to but is not giving us the option to create a new record unless we open the files and save them a second time.

Have any of you folks ran into this issue and if so how did you work around it?

 

[Papi]

I finally figured it out. Part of the code used to open the next file was

ChDir "Y:\PO Reports"
Workbooks.Add Template:="Y:\Templates\PO.xlt"
Application.Goto Reference:="PO_Agreement"

Verses the following (which works fine)

Workbooks.Add(Template:="Y:\Templates\PO.xlt"). _
RunAutoMacros Which:=xlAutoOpen

Thanks for any interest on this matter.