Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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

Community Additions

© 2015 Microsoft