Search notes:

Office Object Model: Excel - Workbooks

The workbooks object is a collection of all workbooks that are currently open in Excel. This object is available as property of the application object.

Properties and methods

`add()`
`application`
`canCheckOut()`
`checkOut()`
`close()`
`count`
`creator`
`item`
`open()`	Opening a workbook might display the message This workbook contains links to one or more external sources that could be unsafe if the Ask to update automatic links under File -> Options -> Advanced -> General is set.
`openDatabase()`
`openText()`
`openXML()`
`parent`

add

workbooks.add creates a new workbook.

The number of worksheets with which the new workbook is created with is determined by the value of DefSheets under the registry key HKEY_CURRENT_USER\Software\Microsoft\Office\_version_\Excel\Options.

This value is exposed in application.sheetsInNewWorkbook.

Index