| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Workbooks.Add method (Excel) |
vbaxl10.chm203073 |
|
|
ea9f2a2c-3cad-0c35-37b5-82da2f24b876 |
05/18/2019 |
medium |
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). |
A Workbook object that represents the new workbook.
If the Template argument specifies a file, the file name can include a path.
[!includeSupport and feedback]