One of my preferred add-ins for VBA development for many years was a small little indenting utility called Smart Indenter. It did one thing, automatically indent code to make it much more legible, but it did it well!
It has always been part of my add-ins page because it was so good:
Microsoft Access Database Add-ins, Tools, Etc.
One thing any good worker will tell you is that you must have the right tools to do the job. Computer programming, MS Access database development, is no exception to this rule! I thought I’d try and list a few add-ins and other useful tools that I have come across, or heard of, in the hopes it could prove useful to other developers. This is an unbiased listing and I have no financial gain from any of the tools listed below. I am simply trying to regroup them to help you find them, and you can judge their usefulness on…
Continue reading →
Sadly, it seemed the product was abandoned by its’ developer some time around when Office 2007/x64 surfaced.
Over the years, I have seen people reporting various hacks to make the older version work with newer versions of office (I report a solution that worked for me), but others report those same hacks not solving the issue for them. So it was a little luck of the draw if you could get it working. I had a few posts on this as well:
Smart Inderter Not Working in Office 2010, 2013
If you do any serious VBA development, you should have heard, and installed, Office Automation Ltd’s Smart Indenter. If you haven’t you should! It is an exceptional FREE tool that helps properly indent your code to help with code legibility & standardization. It offers numerous customizable options to suit your specific needs. That said, I recently tried installing on a machine with Office 2013 and it would not work!? What to do. After so going back and forth with Mz-Tools (another must have VBA developer tool), I finally got it operational. Now, I do not know exactly why or how,…
Continue reading →
Smart Indenter on Win 10 with Access 2013/2016
As posted previously, there are some truly great add-ins for the VBE (VBA Editor), one of which is the Smart Indenter. That said, with the various changes in OS and MS Office products there have been a few bumps in the road trying to get it to install properly with the latest and greatest versions. In a recent thread on UtterAccess, one member reported that they managed to get it properly installed and the solution was to actually install the IndenterVB6.exe rather than IndenterVBA.exe. Seems counter intuitive, but definitely worth trying out so you can continue to use this small,…
Continue reading →
I also saw at one point that it was incorporated into another larger add-in RubberDuck:
Smart Indenter | rubberduckvba.com
The original VB6 source code of the legacy 32-bit Smart Indenter add-in was graciously offered to the Rubberduck project by its owners
Smart Indenter Get a New Life
I recently received an e-mail from Stephen Bullen informing me that a new 64-bit version is now available at:
Office Automation Ltd.
OA Ltd is an independent consultancy for Excel and Access development. This site is the home of Stephen Bullen’s Excel Page, containing many tools and examples for Excel.
specifically, the Smart Indenter page:
Smart Indenter for VBA - Office Addins
Version 4.0.4 is available to download and supports all recent 32-bit and 64-bit Windows versions of Microsoft Office and Microsoft 365.
I have not tried the new version, but will say that the prior versions were exceptional!
I should however mention that his business model has changed, and now, the add-in is no longer free like it had been for decades and a license must be purchased (a 30 day trial version is available however). At the time of writing this post a single license is going for GBP £25.00+taxes.
