MZ-Tools released introducing a Code Explorer and drag & drop in TabIndex Assistant

Last January 1 another monthly build was released, This time, apart from some bug fixes, it introduces a new feature: a file code explorer:

You can read more about the Code Explorer on this post: Moving from MZ-Tools 3.0 to 8.0 Part 32: A Code Explorer.

Also, support for drag & drop in the TabIndex Assistant is reintroduced (this was supported in MZ-Tools 3.0, but not in MZ-Tools 8.0 until now).

The complete changelog is the following:

MZ-Tools released (January 1, 2017)

  • New (VB/VBA): Code Explorer.
  • Enhanced [#11723] (All): Added support for drag & drop in TabIndex Assistant, Switch Assistant and other listviews.
  • Fixed [#11779] (All): The Programming Rules Review didn’t locate results using regular expressions when the found text ended with carriage return without line feed.
  • Fixed [#11775] (All): The Code Element Headers Review caused “Unterminated [] set” with headers that included parameters of array types.
  • Fixed [#11750] (All): The Generate HTML documentation could cause System.Xml.XmlException: hexadecimal value is an invalid character.
  • Fixed [#11739, #11749, #11757] (VB/VBA): The language of the user interface was always English on Windows 7. This bug was introduced in build
  • Fixed [#11766] (VS): The New Method/Property Assistant added quotes to the initial value String.Empty.
  • Fixed [#11804] (VBA): The Find feature could cause System.ArgumentOutOfRangeException when using the VBA editor with double-byte encondings.
  • Fixed [Internal] (VB): The Generate Documentation (XML/HTML) could cause System.NullReferenceException (“System Error &H80004003. Invalid pointer”) if the operation was executed twice.
  • Fixed [Internal] (VBA): The width of buttons on toolbars was not correct when using high-DPI displays.

Moving from MZ-Tools 3.0 to 8.0 Part 32: A Code Explorer

The build released on January 1, 2017, introduces another very requested feature: a Code Explorer. This feature provides you a list with all the code elements of the active code window:

The Code Explorer shows the code elements of the following kinds:

  • Constants
  • Fields
  • Enums
  • Events
  • User-Defined Types
  • Properties
  • Methods

On the toolbar there are seven toggle buttons to show/hide the code elements of a particular kind. Here you can see the Code Explorer showing only fields:

Furthermore, to the right of the toolbar you have a textbox to enter any text, so that only the code elements containing that text are shown:

And selecting any code element in the list shows it in the code window. I hope that you find this tool productive to locate your code faster!

MZ-Tools and released with VS 2017 RC support and bug fixes

The past November 16 a new build was released with some bug fixes and, more importantly, with support for the Visual Studio 2017 Release Candidate 1 announced by Microsoft at the Connect(); 2016 event.

Today a new build has been released with new bug fixes, one of them specially important if you are using Visual Basic 6.0 since the Rename Related Source Code feature was crashing usercontrols.

Also, this month the MZ-Tools website started to use https and this caused a problem in the Check for Updates feature that is now fixed.

The changelogs are the following:

MZ-Tools released (November 16, 2016)

  • New (VS): Added support for VS 2017 RC.
  • Fixed [#11691] (All): The Generate HTML Output Documentation removed indentation of comments in headers.
  • Fixed [#11662] (All): The Dead Code Review didn’t parse correctly statements that were not Dim declarations in lines that started with Dim declarations.
  • Fixed [#11670] (VB/VBA): The Replace feature could cause System.ArgumentOutOfRangeException “Index and length must refer to a location within the string” could happen in some cases.
  • Fixed [#11666] (VBA): LongLong and LongPtr types were not recognized.
  • Fixed [#11695] (VBA): The TabIndex Assistant and other features duplicated a control if the parent was a Frame control inside another Frame control.

MZ-Tools released (December 1, 2016)

  • Fixed [#11715] (All): The Check for updates feature caused “” not found because of https.
  • Fixed [#11716] (All): The Review Code Element Headers could cause System.ArgumentNullException “Value cannot be null”.
  • Fixed [#11724] (All): MZ-Tools entry is no longer created in Control Panel > Programs and features if silent switches are used for automated deployments.
  • Fixed [#11703, #11704] (VB6): Custom control crashed when renamed if the “Rename Related Source Code” feature was activated.

MZ-Tools released with bug fixes

Today a new build has been released, as every month, with some bug fixes. Now I am working on compatibility with VS “15”.

The complete changelog is the following:

MZ-Tools released (November 1, 2016)

  • Fixed [#11589] (All): The Code Library and other tree-based lists were not sorted ignoring case.
  • Fixed [#11613] (All): The Review Headers did not skip DllImport / Declare methods.
  • Fixed [#11638] (VS): System.NotImplementedException “The method or operation is not implemented.” could happen when using SQL Server Database Projects that reference databases.
  • Fixed [#11601] (VB/VBA): The Ctrl+F keyboard shortcut was not allowed to be assigned to the Find Text feature of MZ-Tools to override the Find feature of VB/VBA.
  • Fixed [#11624] (VB/VBA): The New Property Assistant showed an empty list for headers if both Get/Let-Set radiobuttons were selected.
  • Fixed [#11623] (VB/VBA): The Review Dead Code didn’t ignore parameters of callbacks of Ribbon code.
  • Fixed [#11643] (VB5/VB6): The Find text window and the Results window did not work correctly at debug or run-time.
  • Fixed [#11592] (VBA): “System.InvalidCastException: Unable to cast COM object of type ‘System.__ComObject’ to class type ‘System.Windows.Forms.UserControl'” happened if an old version was installed with admin rights and a newer version was installed without admin rights and without uninstalling the previous version.

Introducing MZ-Tools 8.0 for VBA Portable Edition

MZ-Tools 8.0 for VBA, released a year ago, already introduced an innovation in the world of add-ins for the VBA editor allowing to install it without admin rights, something that was quite requested because in many companies users of Office are not admin users (and that’s right).

The build released yesterday, in the first anniversary, introduces yet another innovation in this area: a portable edition. That’s right, you can now run MZ-Tools 8.0 for VBA without running a setup. You can even run it from a USB drive if you want, without copying any file to the hard disk of your computer. This scenario is not so much requested, but it seems that there are companies where users are not allowed (by group policies) to run any kind of setup (even those setups that don’t require admin rights), and maybe even PowerShell or regedit.exe are not allowed either.

So, a portable edition is now provided. The setup edition is still not only provided but also recommended (at least for now). The portable edition is suitable for the scenarios mentioned above.

When you download the portable edition, you get a file that, when unzipped, has this file structure:


There is a MZTools8VBAPortable.exe executable (with a .config file to allow it to run on whatever .NET Framework you have installed, 2.0 or 4.0) and a Files folder, that contains the files (dlls) and the options files (although you can configure the options files anywhere).

When you run the MZTools8VBAPortable.exe file, you get a dialog to register MZ-Tools 8.0 for VBA in the VBA editor:


And, of course, you can unregister it if you want.

MZ-Tools 8.0 Build released

Yesterday it was the first anniversary of MZ-Tools 8.0 for VBA, VB6 and VB5. Happy birthday! I want to thank all the people whose feedback has made this product much better, requesting new features and enhancements, and reporting bugs.

Yesterday also a new build was released, as every month. The complete changelog is the following:

MZ-Tools released (October 1, 2016)

  • New [Internal] (VBA): MZ-Tools 8.0 for VBA Portable edition.
  • Fixed [#11589] (All): The Code Library doesn’t set the focus on the treeview with code templates when shown.
  • Fixed [#11522, #11524] (VB6/VB5): Toolwindows could not be shown (System.InvalidCastException “Unable to cast COM object of type ‘System.__ComObject’ to class type System.Windows.Forms.UserControl”) on Windows 8 or higher if VB6/VB5 is running in compatibility mode with Windows XP. This bug was introduced in build
  • Fixed [#11580] (All): The Headers Review didn’t ignore spaces at the end of a line for VB/VB.NET languages.
  • Fixed [#11589] (VB/VBA): The Esc key allows to close toolwindows.
  • Fixed [#11570] (VB/VBA): The Line Indenting feature caused “System.InvalidOperationException: Indentation of paragraph of file failed” if the file ended with a line with spaces and the last method included line numbers.
  • Fixed [#11544] (VBA): The Options window doesn’t show the Personal / Team options tabs on some configurations (Windows 10 on Parallels).
  • Fixed [#11554] (VBA): The Generate HTML/XML documentation feature crashed the VBA editor of the GE iFix host.
  • Fixed [#11589] (VBA): The Tab key didn’t navigate correctly in the Code Library.
  • Fixed [Internal] (All): The dialog to download an updated version didn’t set correctly the position of a label.
  • Fixed [Internal] (VBA): MZ-Tools could not be loaded in the VBA editor of Office 2000 on Windows XP with .NET Framework 2.0.

MZ-Tools 8.0 Build released with emergency fixes

The last build released last September 1 introduced two important bugs and a previous build introduced two other bugs related to .NET Framework versions that could prevent the load of MZ-Tools 8.0 for VB6/VB5/VBA in some scenarios. I have considered all of them enough important to release the fixes today. I am sorry the inconveniences.

The change log is the following:

MZ-Tools released (September 5, 2016)

  • Fixed [Internal] (All): Error “Creation of tool window failed” when MZ-Tools tries to restore a toolwindow that was left open in the last session.
  • Fixed [Internal] (All): The Quality Review was executed on build (Release configuration) even if no review was set to execute.
  • Fixed [#11477] (VB6/VB5/VBA): MZ-Tools could not be loaded on Windows XP, Windows Vista or Windows 7 without SP1 if .NET Framework 4.0 was not installed. This bug was introduced in build
  • Fixed [#11462] (VB6/VB5/VBA): Toolwindows could not be shown (System.InvalidCastException “Unable to cast COM object of type ‘System.__ComObject’ to class type System.Windows.Forms.UserControl”) on Windows 8 or higher if .NET Framework 3.5 was installed after installing MZ-Tools. This bug was introduced in build

MZ-Tools 8.0 Build released introducing manual sorting of methods and command automation

Yesterday MZ-Tools was released. It introduces some new features and enhancements:

  • The code elements (methods, etc.) can be sorted now manually, in addition to the automatic sorting of previous versions. This was quite requested since MZ-Tools 3.0 provided the Sort Procedures feature that allowed manual sorting.
  • Several features can be now automated from a script (VBScript, PowerShell, etc.). For example, you can add line numbers or execute the quality review or statistics from a script that performs the build. This capability will be documented with samples in the next weeks. If you are already interested, contact me.
  • The TabIndex Assistant is now multiselection, along with other lists. They don’t support drag & drop yet, but it’s on the roadmap.

The complete changelog is the following:

MZ-Tools released (September 1, 2016)

  • New [Internal] (All): Manual sorting of code elements (methods, etc.).
  • Enhanced [#11415] (All): The Quality Review, Line Numbering and other operations can be now automated.
  • Enhanced [#11431] (All): The contents of listviews/treeviews of the Options window can now be copied to the clipboard with Ctrl+C.
  • Enhanced [#10456, #10369] (All): The TabIndex Assistant is now multiselection.
  • Enhanced [Internal] (All): The Switch Assistant is now multiselection.
  • Enhanced [Internal] (All): The Collection editor is now multiselection.
  • Fixed [#11399] (All): The first used toolwindow took longer to load than the next used toolwindows.
  • Fixed [#11445] (All): Result toolwindows already visible were not activated after an operation.
  • Fixed [#11426] (All): The Programming Rules Review didn’t locate correctly results for code elements using operators that find forbidden text (“Not Starting With”, “Not Containing”, “Not Ending With”, “Not Matching”).
  • Fixed [#11473] (All): The Nomenclature Rules editor didn’t preselect the item to review for a new item based on the existing selected item.
  • Fixed [#11403] (VS): ObjectDisposedException happened when removing the Previous/Next Item in Last Window buttons on the main toolbar and prevented Visual Studio from exiting.
  • Fixed [#11463] (VB/VBA): The Find feature did not find correctly carriage returns “\r\n” when using regular expressions.
  • Fixed [#11386] (VB/VBA): Several features didn’t work well with duplicated procedures (which are illegal).
  • Fixed [#11406] (VB/VBA): The Line Indenter didn’t parse correctly End Select statements in the same line than Case or Select Case statements.
  • Fixed [#11420] (VB/VBA): The New Method/Property Assistant didn’t use the terms “Function” and “Subroutine” in the user interface.
  • Fixed [#11456] (VB/VBA): The Find feature didn’t find multilines that included the ‘?’ or ‘#’ characters.
  • Fixed [#11466] (VB/VBA): The Method Callers feature also returned other methods starting with the same name.
  • Fixed [#11415] (VBA): The Review Quality feature prompted to compile the VBA project, which is not supported.
  • Fixed [#11427] (VBA): Any file with “Report” in the name was considered a report file.
  • Fixed [Internal] (All): The context menu of some features (such as Code Library) showed a separator before the first item.
  • Fixed [Internal] (VB/VBA): The Find Text feature didn’t work correctly with the Match Whole Word setting when the searched string did not start or end with word characters.
  • Fixed [Internal] (VB/VBA): The Line Indenter opened the code windows to perform the operation.
  • Fixed [Internal] (VB/VBA): The Line Indenter didn’t parse correctly Next statements with the variable in same cases.
  • Fixed [Internal] (VBA): Several operations saved the VBA project after each file was processed if the setting “Keep modified documents open” was unchecked, causing a bad performance for projects with a large number of files.

MZ-Tools 8.0 Build released introducing Import Files and Clean Project for VBA

Yesterday August 2, MZ-Tools was released. It includes a fix for the previous build released the day before.

Build fixes some bugs and introduces some new features and enhancements:

  • For VBA, the new Import Files feature allows you to import multiple files at the same time to a VBA project. The opposite feature, Export Files, was introduced last month.
  • For VBA, the new Clean Project feature allows you to fix some strange errors in VBA projects caused by junk created by the compiler. This feature works exporting all files, removing them, and re-importing them. There are cleaning utilities on the web, but all of them are 32-bit.
  • The Sort Code Elements feature is now even more powerful. Previously you could use a regular expression on the Name of a method to identify the methods that you want to sort before others. Now you can use the Name or Declaration property (which includes attributes, modifiers, parameters, etc.) and any operator such as “Contains”, “Starts With”, etc. (not only “Matches Regular Expression”).
  • Long operations inside a file can now be cancelled quickly. Previously the cancellation only happened when the operation switched to another file.
  • New predefined variables for the code element declaration and parameter default value.
  • For VB/VBA, support for backreference groups when using the Replace feature with regular expressions.
  • When setting a new folder for the options, if the new folder is empty now you get a prompt to copy existing options. Previously you had to copy the options with the Windows Explorer before changing the folder.
  • A cosmetic change: the “Code Element Header” term has been renamed to just “Header” in all places.
  • An important fix for users of Autodesk products (AutoCAD, Inventor, etc.): the VBA editor no longer crashes when launched in MZ-Tools 8.0 for VBA is installed. This problem was introduced in build (July 1).

The complete changelog is the following:

MZ-Tools released (August 1, 2016)

  • New feature [Internal] (VBA): Import Files.
  • New feature [Internal] (VBA): Clean Project.
  • Enhanced [#10465] (All): The Sort Code Elements feature allows now to set a condition for the Name or Declaration properties.
  • Enhanced [#11305] (All): Long operations inside a file can now be cancelled.
  • Enhanced [#11306] (All): The Replace controls are cleared when a new search is executed.
  • Enhanced [#11308] (All): Added new “Code Element Declaration” predefined variable.
  • Enhanced [#11308] (All): Added new “Parameter Default Value” predefined variable.
  • Enhanced [#11139] (All): When setting a new folder for options, if the folder is empty you get a prompt to copy the current options to that new folder.
  • Enhanced [#11312] (All): Better error messages when inserting code element headers.
  • Enhanced [#11327] (VB/VBA): Added support for backreference groups in the Replace feature when using regular expressions.
  • Enhanced [#11180] (VBA): The Export Files feature generates now a References.txt file with information of references used by the project.
  • Enhanced [Internal] (All): Renamed ‘Code Element Header’ to ‘Header’ in user interface and help file.
  • Fixed [#11323] (All): The Method Callers feature didn’t exclude assignments to the return value at the start of a line of functions and Get properties.
  • Fixed [#11344] (All): When setting a new folder for options, the modifed changes were saved without user’s consent. Now you cannot change the folder if there are pending changes.
  • Fixed [#11261] (VS): The Sort Code Elements feature didn’t handle gracefully the exception that happens when a code region extends beyond the end line of its parent code element.
  • Fixed [#11303] (VB/VBA): The Review Dead Code feature considered dead methods those that were called as parameters (between quotes) of other methods.
  • Fixed [#11310] (VB/VBA): The Method Callers feature didn’t detect calls to methods that were called as parameters (between quotes) of other methods.
  • Fixed [#11320] (VB/VBA): The Line Numbering feature added line numbers to Dim declarations that included “:” in a comment.
  • Fixed [#11328] (VB/VBA): ArgumentOutOfRangeException happened using the Find feature with a regular expression ending with “.”.
  • Fixed [#11356] (VB/VBA): System.ArgumentException (“Invalid procedure call or argument could happen”) happened trying to locate a code element in a file with no code.
  • Fixed [#11385] (VBA): The line indenter feature didn’t parse correctly the “On Error Resume Next” statement if ended with a statement separator “:”.
  • Fixed [#11357] (VBA): The Method Callers feature didn’t detect calls to a Let or Set property after a statement separator “:”.
  • Fixed [#11302] (VBA): Parameters of functions returning arrays were not parsed correctly.
  • Fixed [#11326] (VBA): The Name of a VBA project includes now always the file name but the Project Name predefined variable doesn’t include it.
  • Fixed [#11294] (VBA): The VBA Editor of AutoDesk Inventor crashed when MZ-Tools tried to show a modal window. This bug was introduced in build due to the use of a COM Shim.
  • Fixed [#11339] (VBA): The Autosave feature tried to save read-only documents.
  • Fixed [#11339] (VBA): The Autosave feature caused problems in Excel if the user was editing a cell.
  • Fixed [Internal] (VBA): The uninstaller for VBA didn’t remove some COM-registration when using Settings > System > Apps & features on Windows 10.
  • Fixed [Internal] (VBA): The Toolbars and menus Options section didn’t show the Context Menu: Project > Export Files item.

Exporting all the files of a VBA project to a folder

While VBA offers an Export File menu entry both on the File menu and on the context menu of a file in the Project Explorer, it is inconvenient because you must repeat the operation for each file of a project if you want to export all of them. MZ-Tools introduces a handy feature that allows you to export all the files of a project in a single operation, through an Export Files menu entry:


You are asked the destination folder (which is preset to the last one used during the session):


And all the files of the project are exported to that folder (note: the next build will also export a file with the project references):