Creating a New Workbook Based on an Existing Workbook

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

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

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