Creating a New Workbook Based on a Template

 
Sub addTemp()
    Workbooks.Add Template:= \\server\template\excel\Balance Sheet.xlt
End Sub

1.	Creating a New Workbook Based on an Existing Workbook
2.	xlWBATExcel4IntlMacroSheet: An international macro sheet
3.	xlWBATExcel4MacroSheet: A macro sheet
4.	xlWBATWorksheet: A worksheet

Creating a New Workbook Based on a Template : Workbook Template « Excel « VBA / Excel / Access / Word