W wbl Jan 6, 2004 #1 Hi, How can list all open excel windows and activate a other window by VBA code ? Regards, wbl
B Bob Phillips Jan 6, 2004 #2 Wbl, Does this help? Dim win As Window For Each win In Windows Debug.Print win.Caption Next win Windows("Book1").Activate -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Wbl, Does this help? Dim win As Window For Each win In Windows Debug.Print win.Caption Next win Windows("Book1").Activate -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
