AddOn Listing for Excel

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. It allows saving a default search and inputting a AddOn directory location if it different than the default.

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.

Version 2.7:
- Updated to work with Excel 2007 and some other stuff was done (like browse for directory). Finding slash commands is not working as well since authors are now burying these oommands in variables in the LUA file.

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 some more error checking, including popups

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.

You will notice that the word "Programm," as you've coded it, has 2 "m"s in it (The second instance of "m" has been underlined to aid in your spotting it).

Just get rid of the redundant "m" and all should be well. I'll update my post to let you know if this was the only error preventing me from using your nifty utility.

*Update*

After correcting the error in line 347, I ran the script again and got another error, one I shouldn't have overlooked, heh. I'm on a 64-bit system, and WOW is natively 32-bit. That being the case, I have to change the path in line 347 to include the (x86) portion of of my 32-bit program files directory.

Thinking that solved it, I saved and executed the script again and got the following error, with which I'm stuck:

Run-time error '13':
Type Mismatch

I entered Debug Mode and the debugger took me to the following code, highlighting it as the source of this error:

Line 70, coded as follows:

Columns("A:ZZ").EntireColumn.Delete

If I'm understanding the code correctly, the block of code that statement belongs to is telling Excel to delete every column in the spreadsheet?

I'm not sure if that's correct or not, or why it would want to do that. This error is beyond my scope of knowledge with VB.

I hope this helps, and that it can be resolved. I was really looking forward to working with this utility.

*/Update*

Thanks,
Direbane.

Nice research. I just commented that line out and it worked like a charm for me.

You will notice that the word "Programm," as you've coded it, has 2 "m"s in it (The second instance of "m" has been underlined to aid in your spotting it).

Just get rid of the redundant "m" and all should be well. I'll update my post to let you know if this was the only error preventing me from using your nifty utility.

*Update*

After correcting the error in line 347, I ran the script again and got another error, one I shouldn't have overlooked, heh. I'm on a 64-bit system, and WOW is natively 32-bit. That being the case, I have to change the path in line 347 to include the (x86) portion of of my 32-bit program files directory.

Thinking that solved it, I saved and executed the script again and got the following error, with which I'm stuck:

Run-time error '13':
Type Mismatch

I entered Debug Mode and the debugger took me to the following code, highlighting it as the source of this error:

Line 70, coded as follows:

Columns("A:ZZ").EntireColumn.Delete

If I'm understanding the code correctly, the block of code that statement belongs to is telling Excel to delete every column in the spreadsheet?

I'm not sure if that's correct or not, or why it would want to do that. This error is beyond my scope of knowledge with VB.

I hope this helps, and that it can be resolved. I was really looking forward to working with this utility.

Originally posted by MiklaDfar Make sure you have macro security set to medium (Tools-Options-Security-Macro Security-Medium). Then close and re-open Excel. Click "Enable" when you are asked if you wish to run macros.

Also, you can hit Alt-F11 to open the IDE and see the code to make sure it is there. While in the IDE you can also open the Immediate window (View-Immediate Window) to see if there are any errors listed there... if so, please post them (the GetReg: message is not an error).

It works, though I am still working out a few minor bugs. If you have a LOT of addons (say over 150), then it may take 30 seconds or so to work through all the directories.

tried the 4.2 also

did the Alt-F11 then the View-Immediate Window
looked through code and found you had hard wired the ADDON directory

i have it on the D:\ so you can't find me
i tried to edit it but it did not save i think

BTW i assume i am unzip into the ADDON directory or should it be someplace else

please allow us to re-direct to our directorys as some of use do not use same nameing conventions for security reasons.....

not every one uses the "C:/program files" as there game directory .... "D:\Games" is my stile on some of my machines

If you press Alt-F11, is the code there? It is odd that it does nothing, but it could be the error checking that I added is just letting the macro fall through. But you should at least get the menu. The latest version (2.3) adds some popup messages when an error is encountered... try it.

Also, where is you addon folder located (drive:/path)?

Originally posted by Joeniel Why wont this work? What am I doing wrong? It does absolutely nothing, and yes the macro security option is on medium.

Make sure you have macro security set to medium (Tools-Options-Security-Macro Security-Medium). Then close and re-open Excel. Click "Enable" when you are asked if you wish to run macros.

Also, you can hit Alt-F11 to open the IDE and see the code to make sure it is there. While in the IDE you can also open the Immediate window (View-Immediate Window) to see if there are any errors listed there... if so, please post them (the GetReg: message is not an error).

It works, though I am still working out a few minor bugs. If you have a LOT of addons (say over 150), then it may take 30 seconds or so to work through all the directories.

Originally posted by VincentSDSH Tried this on a lark and it did precisely...nothing. No data generated, no evidence of macro execution at all.