22.3. Working with Workbooks
In many of your Excel procedures, you'll need to work with Workbooks: creating new Workbooks, saving Workbooks in various locations and formats, opening existing Workbooks, closing Workbooks, and printing Workbooks. To do so, you work with the Workbooks collection, which contains a Workbook object for each open Workbook in Excel.
22.3.1. Creating a Workbook
To create a new Workbook, use the Add method with the Workbooks collection. The syntax is as follows:
Here, Template is an optional Variant argument that specifies how to create the workbook. The following subsections discuss the available options.
220.127.116.11. Creating a New Blank Workbook
To create a blank Workbook (as if you'd clicked ...