Edit

Share via

Application.Windows property (Project)

  • Article

Gets a Windows collection representing the open windows in the application. Read-only Object.

Syntax

expression.Windows

expression A variable that represents an Application object.

Remarks

The Windows property duplicates the Windows2 property, except that it returns a Windows collection rather than a Windows2 collection. The Windows2 property and Windows2 collection object are recommended for all new development both in VBA and for external applications developed with the .NET Framework. The Windows property and Windows collection are maintained for backward compatibility with existing applications.

Example

The following example cascades all the open windows.

Sub CascadeWindows() 
 Dim I As Integer 
 
 ActiveWindow.WindowState = pjNormal ' Restore the window. 
 
 With Application.Windows 
 For I = 1 To .Count 
 .Item(I).Activate 
 .Item(I).Top = (I - 1) * 15 
 .Item(I).Left = (I - 1) * 15 
 Next I 
 End With 
 
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.