Wendell A. Clark wrote:
If you save as a template then the user would be asked to rename it or it
would be given a name + 1,2, (next sequence number)


ActiveWorkbook.SaveAs "aaa", xlTemplate
ActiveWorkbook.Close
Workbooks.Open "aaa"


It makes sense. It is similar to what I wanted to achive. Thanks.