Workbooks.Add method (Excel)

Creates a new workbook. The new workbook becomes the active workbook.


expression.Add (Template)

expression A variable that represents a Workbooks object.


Name Required/Optional Data type Description
Template Optional Variant Determines how the new workbook is created. If this argument is a string specifying the name of an existing Microsoft Excel file, the new workbook is created with the specified file as a template.

If this argument is a constant, the new workbook contains a single sheet of the specified type. Can be one of the following XlWBATemplate constants: xlWBATChart, xlWBATExcel4IntlMacroSheet, xlWBATExcel4MacroSheet, or xlWBATWorksheet.

If this argument is omitted, Microsoft Excel creates a new workbook with a number of blank sheets (the number of sheets is set by the SheetsInNewWorkbook property).

Return value

A Workbook object that represents the new workbook.


If the Template argument specifies a file, the file name can include a path.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.