VBA tools are important for any vba developer – today I was thinking to summarize the tools I am using daily and to update the list of them with the time. The order of the tools is pretty much random.
If you need to write xml code to change the ribbon of a *.xml file and you are tired to change the extension to *.zip every time you need to change it, the tool is just your thing!
Have you ever received a code from a colleague who has left the company? The colleague has never used indentation and the code looks horrible. Smart Indent is here to do it for you, working for 32 bit Excel only. The source code of SmartIndenter is included in RubberDuck as well!
TDD Library – GitHub
You have tried Python or C# and you know what TDD is? You are interested to apply it in VBA? TDD is really your thing. Open source code from GitHub, working quite good!
VBA Boilerplate – GitHub
My idea is that when I start a project in VBA, I should not reinvent the wheel every time. Thus, I have created a boilerplate with the most used functions + the TDD Library inside. Saving some minutes of coding.
The initial documentation is here – vitoshacademy.com/boilerplate
The idea of Unviewable+ is to protect your code in the VB Editor in a way, that nobody (including you) is able to access it. And it works pretty well.
AutoMacro is an add-in for VBA that installs directly into the Visual Basic Editor. It comes loaded with code generators, an extensive code library, the ability to create your own code library, and many other time-saving tools and utilities.