VBA rookie here.

Is it possible to get VBA to count the number of active applications in
Windows? I dont mean counting the number of Excel workbooks opened within
the Excel application but the number of applications that are active within
Windows itself. Say if I have launched Word, Notepad, Powerpoint, Excel and
SAP application, the count should return 5.

If this is possible, then how can I also get it to Debug.Print each
applications name?

Currentlly, Im using sendkeys "%{TAB}" to tab to-and-fro the next
application. This is very dangerous. With your answer, I hope to get VBA to
activate the intended application rather than using ALT+TAB.

Thanks in advance
--
Edmund
(Using Excel XP)