|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
How to: Create New Workbooks
Some code examples in this topic use the this or Me keyword or the
Thecollection in Microsoft Office Excel 2003 makes it possible to create a new workbook, and import data into a new workbook. However, since you add the workbook programmatically, it is a native object and does not have the additional events and data-binding capabilities of a host item.
To create a new workbook
Use themethod of the Workbooks collection.
You can also specify the name of a workbook template as a parameter to the Add method.