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.
Wednesday 17 January 2018
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.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment