Excel AddOn Listing

This is an Microsoft Excel spreadsheet that looks through your AddOn directory and pulls useful information out of all your addons into an excel spreadsheet. This includes the Name, Version, Slash Commands, Dependendcies, Notes, Author, etc.

The only file writes it does is save a configuration file in the AddOn directory and a singe registry entry that contains the location of the configuration file. But, it only does this if you save a search as a default.

Make sure Macro Security is set to medium (Tools-Options-Security-Macro Security).

Version 2.4 -Added ability to highlight Ace2 compatible addons (if version hightlighting is also checked, the only first column is highlighted) -Added option to clean up title (remove color codes)

Version 2.3.1:

Credit to: Naralia
Added a function to save boolean values in english language even with a german client
Version 2.3:

Added a check at the beginning of the code to make sure the AddOn directory exists
Added a little more error checking to make sure there are valid files/directories in the varfiles array
Version 2.2:

Added Option Explicit
Fixed some variables not declared that could force some errors, specifically in the For Each loops
Added borders and fixed interface version highlighting
Modified code to handle the AddOn folder being on a different drive (removed use of ChDir)
Added a check to make sure there were directory names in the varFiles array before trying to open them
Added some more error checking (more to come)'Version 2.1:
Added some error checking around the For...Next loops to avoid empty lines and also checking that there are no weird files in the AddOn directory that could be confused as real directories.
Version 2.1:

Added some error checking around the For...Next loops to avoid empty lines and also checking that there are no weird files in the AddOn directory that could be confused as real directories.
Version 2:

Added ability to save defaults in the form (saves a cfg file in the AddOn directory). This also prompted a requrement to add a registry key in HKEY_CURRENT_USER\Software\VB and VBA Program Settings\ in order to remember where the configuration file is for getting defaults
Added ability to change AddOn directory location
Version 1:

Added input/selection criteria form
Added addtional parameters to search for
Added highlighting for AddOns that were not current
Added an error check to correct problem some users were having

Version 2.4
-Added ability to highlight Ace2 compatible addons (if version hightlighting is also checked, the only first column is highlighted)
-Added option to clean up title (remove color codes)

Version 2.3.1:

Credit to: Naralia
Added a function to save boolean values in english language even with a german client
Version 2.3:


Added a check at the beginning of the code to make sure the AddOn directory exists
Added a little more error checking to make sure there are valid files/directories in the varfiles array

Version 2.2:

Added Option Explicit
Fixed some variables not declared that could force some errors, specifically in the For Each loops
Added borders and fixed interface version highlighting
Modified code to handle the AddOn folder being on a different drive (removed use of ChDir)
Added a check to make sure there were directory names in the varFiles array before trying to open them
Added some more error checking (more to come)'Version 2.1:
Added some error checking around the For...Next loops to avoid empty lines and also checking that there are no weird files in the AddOn directory that could be confused as real directories.

Version 2.1:

Added some error checking around the For...Next loops to avoid empty lines and also checking that there are no weird files in the AddOn directory that could be confused as real directories.

Version 2:

Added ability to save defaults in the form (saves a cfg file in the AddOn directory). This also prompted a requrement to add a registry key in HKEY_CURRENT_USER\Software\VB and VBA Program Settings\ in order to remember where the configuration file is for getting defaults
Added ability to change AddOn directory location

Version 1:

Added input/selection criteria form
Added addtional parameters to search for
Added highlighting for AddOns that were not current
Added an error check to correct problem some users were having