Which windows are open?
 

Is there a way of listing all open windows names in vba?

TIA

Nath.

Which windows are open?
 

Nath,

Try something like

Dim Wnd As Window
For Each Wnd In Application.Windows
Debug.Print Wnd.Caption
Next Wnd



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"nath" wrote in message
...
Is there a way of listing all open windows names in vba?

TIA

Nath.

Which windows are open?
 

Dim wnd

For Each wnd In Windows
Debug.Print wnd.Caption
Next wnd


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"nath" wrote in message
...
Is there a way of listing all open windows names in vba?

TIA

Nath.