VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
As you can see sometimes these techniques can get rather complicated, however in reality most of the complexities of this task can be hidden behind an abstraction. This is where I suggest the use of the stdVBA library. This library (created by myself) contains some simple abstractions of the IAccessible API and work in conjunction with stdLambda to help you create small utilities like the above, with very little effort:
Defeat 'Project Unviewable' protection
1 project | reddit.com/r/excel | 7 Jul 2022
I Recreated Wordle in Microsoft Word
1 project | reddit.com/r/shittyprogramming | 9 Jun 2022
How do I uninstall a Word extension on macOS? Urgent help needed!
1 project | reddit.com/r/techsupport | 2 Jun 2022
Popis svih hrvatskih riječi sa 5 slova
1 project | reddit.com/r/croatia | 25 May 2022
[Access] Any alternatives to Scripting.TextStream that eat up less memory?
1 project | reddit.com/r/vba | 25 May 2022