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

Материал из VB Эксперт
Перейти к: навигация, поиск

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>