Creating a New Workbook [Excel 2003 VBA Language Reference]
To create a new workbook in Visual Basic, use the Add method. The following procedure creates a new workbook. Microsoft Excel automatically names the workbook BookN, where N is the next available number. The new workbook becomes the active workbook.
Sub AddOne()
Workbooks.Add
End Sub
A better way to create a new workbook is to assign it to an object variable. In the following example, the Workbook object returned by the Add method is assigned to an object variable, newBook
. Next, several properties of newBook
are set. You can easily control the new workbook using the object variable.
Sub AddNew()
Set NewBook = Workbooks.Add
With NewBook
.Title = "All Sales"
.Subject = "Sales"
.SaveAs Filename:="Allsales.xls"
End With
End Sub
See Also | Opening a Workbook