MZ-Tools 22.214.171.124 has just been released with a few bug fixes:
- Fixed [336-1B1EFE8F-0201]: The Code Element Headers feature didn’t provide the “Parent Code Element Full Name” predefined variable.
MZ-Tools 126.96.36.199 has just been released with a few bug fixes:
After a few months without updates, MZ-Tools 188.8.131.52 has just been released with a few bug fixes:
MZ-Tools 184.108.40.206 has just been released with a few bug fixes, most of them to provide a better experience with 3rd party software:
If you are using SkyDrive to store the Team Options of MZ-Tools 7.0 (to share them among several computers of yours), you can get the following error on Windows 8.1 (but not on Windows 7 or Windows 8):
“System.IO.IOException: The file cannot be accessed by the system”
This issue will be addressed in the next build to fail more gracefully with a friendly explanation, but meantime the workaround is the following:
The most common question that I receive about MZ-Tools 3.0 for VBA is how to install it without administrator rights or the variant “I don’t see MZ-Tools after an administrator installed it”.
The short answer is that you can’t install MZ-Tools 3.0 for VBA without being an administrator. This is because the add-in dll must be registered as COM component, and in this version 3.0 it uses machine-wide COM-registration (using the HKEY_LOCAL_MACHINE registry hive, like regsvr32.exe does).
Note: It happens that per-user COM-registration is possible (not requiring admin rights), and the new major version MZ-Tools 8.0 for VBA will avoid this problem. But meantime, you need to persuade an administrator to install it as the first step.
Once an administrator has installed the add-in, a problem remains: VBA add-in registration (which is different from COM-registration) is badly designed and the VBA editor only looks for add-ins in the HKEY_CURRENT_USER registry hive. So, when the administrator installed the add-in, it wrote registry entries in her HKEY_CURRENT_USER registry hive. Since they are missing in your HKEY_CURRENT_USER registry hive, you “don’t see” the add-in. Fortunately nothing prevents you writing in your HKEY_CURRENT_USER registry hive even lacking administrator rights, so you can create a program with any technology (.NET, VB6, VBA macro, VBScript, PowerShell, etc.) to write these entries:
Value: MZ-Tools 3.0 for VBA
Value: MZ-Tools 3.0 for VBA
In the FAQ entry about this issue I have provided a PowerShell script that writes those entries.
MZ-Tools 220.127.116.11 has just been released with a couple of bug fixes and a small enhancement that a customer requested:
MZ-Tools 18.104.22.168 has just been released with several bug fixes:
MZ-Tools 22.214.171.124 has just been released with support for Visual Studio 2013 Preview and a couple of bug fixes:
MZ-Tools 126.96.36.1991 has just been released with the fixes below.
The first one can prevent an “Out of memory” error when adding / removing line numbers in the VBA editor of Microsoft Access databases because now MZ-Tools closes the forms and reports that Access opens automatically when editing their code files. This issue has affected a number of users in the last years (at least since Access 2007) but now a workaround has been implemented.
The second one prevents an error installing MZ-Tools if you have installed Visual Studio 2013 Preview.