Application.NewWorkbook property (Excel)

Returns a NewFile object.

Syntax

expression.NewWorkbook

expression An expression that returns an Application object.

Return value

NewFile

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.