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






Creating a New Workbook Based on a Template

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

 








Related examples in the same category

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