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.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.
Originally posted by Direbane Thanks for coding this, I haven't quite gotten it to work for me yet but I appreciate your work nonetheless.
I want to inform you and your users of a typographical error I've detected in the code for form frmSelect.
In subroutine:
Private Sub UserForm_Initialize()
Line 347 is coded as follows:
txtDirectory.value = "C:\Programm Files\World of Warcraft\Interface\AddOns"
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.
Last edited by ceyounger : 08-06-2009 at 11:55 AM.
lol I'm confused *sniffles* Is it updated? I'd love to try this out, but I want to make sure it's working as intended...being as the list date is older, I am double-checking lol
__________________ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Words to Remember:
"You never really learn much from hearing yourself talk." ~ George Clooney
**Jeania/Anjelie ~ Dalaran** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thanks for coding this, I haven't quite gotten it to work for me yet but I appreciate your work nonetheless.
I want to inform you and your users of a typographical error I've detected in the code for form frmSelect.
In subroutine:
Private Sub UserForm_Initialize()
Line 347 is coded as follows:
txtDirectory.value = "C:\Programm Files\World of Warcraft\Interface\AddOns"
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 cireyoretihw sorry i ment 2.4
both versions i did the alt-F8 and Run "OpenSelectForm"
then modified the ADDON path to "D:\Programm Files\World of Warcraft\Interface\AddOns"
compiler error
Sub or Function not defined
in source
aSlash = Split(tLine, Chr(10)) 'Check to see if we only got one line
??Split???
hope this helps
i just downloaded the "WowAddOnListing" amd ot works as advertized ?
had the WOW think it was a VIRUS because i had it the ADDON directory but when i put it exe into its own director in the ADDON directory it had no problems with it.....
PLEASE fix other tools as i think you have some great skills....
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)?
Quote:
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.
Quote:
Originally posted by VincentSDSH Tried this on a lark and it did precisely...nothing. No data generated, no evidence of macro execution at all.
Last edited by MiklaDfar : 02-25-2007 at 07:47 AM.
Great!
