NewWorkbook Property [Excel 2003 VBA Language Reference]

  • Article

Returns a NewFile object.

expression.NewWorkbook

expression Required. An expression that returns one of the objects in the Applies To list.

Example

In this example, Microsoft Excel sets the variable wkbOne to a NewFile object.

Sub SetStartWorking()

    Dim wkbOne As NewFile

    ' Create a reference to an instance of the NewFile object.
    Set wkbOne = Application.NewWorkbook

End Sub

Applies to | Application Object