Application.Resize procedure builder

Application.Resize (Word)

Sizes the Word application window or the specified task window.

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

Resize (Width, Height)

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


The following arguments are required:

Width (Long) - The width of the window, in points.

Height (Long) - The height of the window, in points.