Application.Workbooks

This property returns a collection of all open workbooks.

This property is read only.

Syntax Parameters Return Value
- - StaDocuments

SVB Example

Creating a new workbook:

Option Base 1
Option Explicit
Sub Main
    Dim wk As Workbook
    Set wk = Application.Workbooks.New("New Workbook")
    wk.Visible = True
End Sub