Create a Workbook

To create a workbook in Visual Basic, use the Add method. The following procedure creates a workbook. Microsoft Excel automatically names the workbook Book N, 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 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 by 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

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.