VBA - Equivalent of Spy++ - thanks to Mark Rowlinson

Sometimes, a VBA developer must break out if the VBA sandbox and resort to calling the Windows API directly; in these cases it is often to manipulate or interact with a window for which the developer needs to acquire the window's handle. A good program to investigate the structure and hierarchy of windows of an application is Spy++ (SpyXX.Exe) which dates back Visual Studio 6.0. Here is a screenshot showing the Excel windows and there are many.

Thanks to a clever guy called Mark Rowlinson there is some clever code which replicates the output of Spy++. The code is over at VBA Express. Here is a screenshot of the Excel windows details.