VBA/Excel/Access/Word/Excel/Workbook Template

Creating a New Workbook Based on an Existing Workbook

 
Sub add()
    Workbooks.Add Template:= "C:\Business\Personnel.xls"
End Sub

Creating a New Workbook Based on a Template

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

xlWBATExcel4IntlMacroSheet: An international macro sheet

 
Sub add()
    Workbooks.Add Template:=xlWBATExcel4IntlMacroSheet
End Sub

xlWBATExcel4MacroSheet: A macro sheet

 
Sub add()
    Workbooks.Add Template:=xlWBATExcel4MacroSheet
End Sub

xlWBATWorksheet: A worksheet

 
Sub add()
    Workbooks.Add Template:=xlWBATWorksheet
End Sub