Download
(38Kb)
Download
Updated: 12-01-10 06:31 AM
Pictures
File Info
Updated:12-01-10 06:31 AM
Created:unknown
Downloads:4,934
Favorites:32
MD5:

AddOn Listing for Excel

Version: v2.7
by: MiklaDfar [More]

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.

Optional Files (0)


Post A Reply Comment Options
Unread 08-06-09, 10:54 AM  
ceyounger
A Kobold Labourer
 
ceyounger's Avatar

Forum posts: 1
File comments: 2
Uploads: 0
Re: Typographical Error

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-09 at 10:55 AM.
Report comment to moderator  
Reply With Quote
Unread 07-13-09, 06:46 PM  
Jeania
An Aku'mai Servant
 
Jeania's Avatar

Forum posts: 39
File comments: 170
Uploads: 0
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*۝*
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Report comment to moderator  
Reply With Quote
Unread 04-11-09, 11:44 AM  
Direbane
A Kobold Labourer

Forum posts: 1
File comments: 13
Uploads: 0
Typographical Error

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.
Last edited by Direbane : 04-11-09 at 12:19 PM.
Report comment to moderator  
Reply With Quote
Unread 04-10-08, 12:01 AM  
StarAngel
A Kobold Labourer

Forum posts: 0
File comments: 4
Uploads: 0
Great!
Report comment to moderator  
Reply With Quote
Unread 01-06-08, 10:34 AM  
cireyoretihw
A Kobold Labourer

Forum posts: 0
File comments: 3
Uploads: 0
Re: Sub or Function not defined

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....
Report comment to moderator  
Reply With Quote
Unread 01-05-08, 06:41 PM  
cireyoretihw
A Kobold Labourer

Forum posts: 0
File comments: 3
Uploads: 0
Sub or Function not defined

Originally posted by cireyoretihw
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
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
Report comment to moderator  
Reply With Quote
Unread 01-05-08, 02:03 PM  
cireyoretihw
A Kobold Labourer

Forum posts: 0
File comments: 3
Uploads: 0
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
Report comment to moderator  
Reply With Quote
Unread 02-25-07, 02:50 PM  
Vetus
A Murloc Raider
 
Vetus's Avatar

Forum posts: 6
File comments: 59
Uploads: 0
Mine didn't run (without help) either... But I did this...

Alt-F8

That opens the Macro window... Now click 'run'


My compliments... I already had a SS that I was manually keeping up to date..

I like yours better

Thanks for all your work!!
Report comment to moderator  
Reply With Quote
Unread 02-25-07, 11:40 AM  
MiklaDfar
A Kobold Labourer
AddOn Author - Click to view AddOns

Forum posts: 0
File comments: 3
Uploads: 5
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.
Report comment to moderator  
Reply With Quote
Unread 02-25-07, 09:56 AM  
Joeniel
A Kobold Labourer

Forum posts: 0
File comments: 1
Uploads: 0
Why wont this work? What am I doing wrong? It does absolutely nothing, and yes the macro security option is on medium.
Report comment to moderator  
Reply With Quote
Unread 02-25-07, 07:32 AM  
MiklaDfar
A Kobold Labourer
AddOn Author - Click to view AddOns

Forum posts: 0
File comments: 3
Uploads: 5
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.
Last edited by MiklaDfar : 02-25-07 at 07:47 AM.
Report comment to moderator  
Reply With Quote
Unread 02-25-07, 01:42 AM  
VincentSDSH
Non-Canadian Luzer!
 
VincentSDSH's Avatar
AddOn Author - Click to view AddOns

Forum posts: 350
File comments: 257
Uploads: 12
Tried this on a lark and it did precisely...nothing. No data generated, no evidence of macro execution at all.
Report comment to moderator  
Reply With Quote
Unread 02-23-07, 10:12 PM  
wulfy27
Addon Junkie
 
wulfy27's Avatar

Forum posts: 21
File comments: 8
Uploads: 0
I kid you not, I was working on this a few days ago and bonked all my addons. THANKYOU!!
__________________
Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump: