Beta: ProfitUI Quick Macro Button Configurator

[gm9]

-- This is now available from the download area --.

So I'm sitting in a hotel room on a business trip, can't sleep and felt like doing some coding.

Attached is a modified version of Ornathian's great All Spell Guide table that can be used to automatically configure your ProfitUI quick macro buttons with level detecting code for entire spell lines.

Operation is very simple (I hope):

• You must have Microsoft Excel running on Windows. Should be compatible with most if not all Excel versions out there as far as I can tell. Might convert this to something more portable one day, but for now that's all you get. Also, you must enable macros to run in this table.
• You will see a huge table listing all spells/abilities in the game (or so Ornathian claims, but I haven't found anything missing so far). Select any one of them (click anywhere on the line containing it).
• Now click the huge red button, select your eq2 path and the macro button you want to configure (1 to 5).
• When you hit "Save", level detecting macro code for the entire spell line will automatically be written to _ProfitUI_QuickRaidButtons.txt in your ProfitUI folder. Do me a favor and make a backup of that file first!
• Rinse and repeat for any other spell for any other subclass you want to configure
• The eq2 path will be stored if you save the worksheet when you close it.

Feedback and bug reports are appreciated. It seems to work fine, but then again it's past 3 a.m. in the morning here, who know's how reliable I'm coding at this time. Error handling is pretty minimal at this point.

Should be a very useful tool if it's working though I hope. Thanks for testing.

Version history:
beta 8 - hopefully works with Excel 2000 now
beta 7 - uses ProfitUI 4.5 level detection code based on non-mentored level. Also tooltips now comprise the entire spell line including the level for each spell.
beta 6 - added possibility to add /raidsay, /groupsay, /say and /tell text
beta 5 - colors for calain80
beta 4 -

• Fixed a bug where a spell line would always be saved to button 1 regardless of your selection in certain circumstances
• Added complete error handling for eq2 path selection and detecting of an existing ProfitUI installation.
• Your settings of the table (filters, selected cell) will now be restored after saving a spell line
• Spell lines with only 1 spell no longer have "line" in the tooltip and the spell name is no longer enclosed in apostrophs

beta 3 - fix for level detection that always tried to use the next higher instead of the current spell (bug introduced with beta 2 I think)
beta 2 - fix for spells with apostrophs
beta 1 - initial release