<

Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Installing Smart Indenter in Office 2013-2016

Published on
7,023 Points
3,823 Views
2 Endorsements
Last Modified:
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Overview
One of the most useful tools in the VBA\VB Classic developers arsenal is Office Automation Ltd’s Smart Indenter. This extremely powerful, yet small, lightweight and free VBE COM addin, is a must(!) for any serious VBA\VB Classic developer. Using it you can with the click of a button properly indent your code to improve the code legibility and standardization. It offers numerous customizable options to suit your habits and personal taste.

Summary
Unfortunately, it cannot be installed properly with MS Office version 2013 and higher. Inspecting the addin's install log will show where the error occurred:
Could not Self-Register: C:\PROGRA~2\OFFICE~1\SMARTI~1\VBA6\INDENT~1.DLL

Open in new window


Cause
This issue occurs because the Smart Indenter addin was built in VB6 and interfaces with the latest version (6.1.98.16) of a dll file (msaddndr.dll) which was  discontinued by Microsoft and therefore is no longer installed with MS Office.


Solution


The solution is to manually copy msaddndr.dll to your computer before installing Smart Indenter.

1. Delete the msaddndr.dll file from the following location:

In a 32-bit version of an operating system:

%commonprogramfiles%\DESIGNER

In a 64-bit version of an operating system:

%commonprogramfiles(x86)%\DESIGNER

2. Copy the msaddndr.dll file to the aforementioned location.
3. Install IndenterVBA.exe
 

You can copy msaddndr.dll from an old system or download it from www.dll-downloader.net 
The addin can no longer be downloaded from the developers website. Therefore the author of this article has uploaded it to Google Drive. The addin, dll and this article can be downloaded from here.

Alternative Solution
Some users have reported that installing Mz-Tools before installing Smart Indenter solved the problem, while others reported that it made no difference.
Investigating these reports, it seems that installing Mz-Tools will only solve the problem if msaddndr.dll does not exist on the system. The explanation for this is that Mz-Tools will only copy the msaddndr.dll file if it doesn't exist, but if an earlier version does exist it won't be over-written. Since Smart Indenter needs the last version of msaddndr.dll (6.1.98.16) it won't work.
The free version (3.0) of Mz-Tools is lo longer available from their website, but can be downloaded from Google Drive.

Disclaimer
The author of this article has no vested interest in Smart Indenter or Mz-Tools. Smart Indenter is freeware which is no longer supported by its developer due to his retirement back in 2005. Mz-Tools version 3.0 is freeware but is no longer available from their website. This article was written after its author finally figured out how to properly install the addin after struggling with it for quite some time.
2
Comment
Author:MacroShadow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 66

Expert Comment

by:Jim Horn
If you could add a paragraph painting a picture of what you just said then we'll be good.
0
 
LVL 66

Expert Comment

by:Jim Horn
Nicely written.  I'm currently in an Oracle shop that has a wompload of .xml, .sql, and Java files that are used to build a monster data warehouse where using a tool like this is very important for supporting code.  

Voted Yes.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Join & Write a Comment

This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Progress
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month