This documentation is archived and is not being maintained.

Application.Resize Method

Office 2007
Sizes the Word application window or the specified task window.


expression.Resize(Width, Height)

expression   Required. A variable that represents an Application object.


NameRequired/OptionalData TypeDescription
WidthRequiredLongThe width of the window, in points.
HeightRequiredLongThe height of the window, in points.


If the window is maximized or minimized, an error occurs. Use the Width or Height property to set the window width and height independently.


This example resizes the Microsoft Excel application window to 6 inches wide by 4 inches high.

Visual Basic for Applications
If Tasks.Exists("Microsoft Excel") = True Then
    With Tasks("Microsoft Excel")
        .WindowState = wdWindowStateNormal
        .Resize Width:=InchesToPoints(6), Height:=InchesToPoints(4)
    End With
End If

This example resizes the Word application window to 7 inches wide by 6 inches high.

Visual Basic for Applications
With Application
    .WindowState = wdWindowStateNormal
    .Resize Width:=InchesToPoints(7), Height:=InchesToPoints(6)
End With