VBA/Excel/Access/Word/Excel/Workbook Template
Содержание
Creating a New Workbook Based on an Existing Workbook
<source lang="vb">
Sub add()
Workbooks.Add Template:= "C:\Business\Personnel.xls"
End Sub
</source>
Creating a New Workbook Based on a Template
<source lang="vb">
Sub addTemp()
Workbooks.Add Template:= \\server\template\excel\Balance Sheet.xlt
End Sub
</source>
xlWBATExcel4IntlMacroSheet: An international macro sheet
<source lang="vb">
Sub add()
Workbooks.Add Template:=xlWBATExcel4IntlMacroSheet
End Sub
</source>
xlWBATExcel4MacroSheet: A macro sheet
<source lang="vb">
Sub add()
Workbooks.Add Template:=xlWBATExcel4MacroSheet
End Sub
</source>
xlWBATWorksheet: A worksheet
<source lang="vb">
Sub add()
Workbooks.Add Template:=xlWBATWorksheet
End Sub
</source>