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

TIA

Nath.

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.

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.