How to: Programmatically Create New Workbooks

  • Article

When you create a workbook programmatically, it is a native Workbook object, not a Workbook host item.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2013 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

You can generate a 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

  • Use the Add method of the Workbooks collection.

    Dim newWorkbook As Excel.Workbook = Me.Application.Workbooks.Add()

    Excel.Workbook newWorkbook = this.Application.Workbooks.Add();

    Note

    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 method.

See Also

Tasks

How to: Programmatically Open Workbooks

How to: Programmatically Save Workbooks

How to: Programmatically Close Workbooks

Concepts

Extending Word Documents and Excel Workbooks in Application-Level Add-ins at Run Time

Adding Controls to Office Documents at Run Time

Working with Workbooks

Programmatic Limitations of Host Items and Host Controls

Optional Parameters in Office Solutions

Host Items and Host Controls Overview