How to: Create New Workbooks
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.
Microsoft Office version
For more information, see Features Available by Application and Project Type.
Starting in Visual Studio 2008 Service Pack 1 (SP1), you can generate a Microsoft.Office.Tools.Excel.Workbook host item for a Workbook object in an application-level project. For more information, see Extending Word Documents and Excel Workbooks in Application-Level Add-ins at Run Time.
To create a new workbook
Dim newWorkbook As Excel.Workbook = Me.Application.Workbooks.Add()
Excel.Workbook newWorkbook = this.Application.Workbooks.Add(missing);
You can create a workbook based on a template other than the default template: pass the template you want to use as a parameter to the Add(Object) method.