Macro config questions

shrek_fx · #1 02-21-2008, 12:23 PM

I downloaded the macro config thing and wondering if you can tell me or point me to the right direction on how to use it?.. I use Open Office and dont know it its compatible with that.. also i see the table, but dont see the macro setup window... Thanks again for the help and the great ui

ShadowProwler420 · #2 02-21-2008, 03:17 PM

From what a couple of the posts in this thread says, the macro configurator isn't compatible with Open Office.

The same thread also has some basic instructions that should help you get started with it.

shrek_fx · #3 02-21-2008, 03:58 PM

o.k. thanks.. thats a bummer cuz i dont like giving my money to microsoft LOL.. i'll figure something out though..

sorinth · #4 02-21-2008, 06:25 PM

Yup, I guess I was on the 'beta team'... it is not compatible with open office. Actually, open office does have issues with macro's written for excel. That is the only problem that I have seen with it so far (I use both almost daily at work).

However, it works with excel 2000 and excel 2003

**gm9** · #5 02-21-2008, 06:32 PM

Next time I'm bored I'll check whether it can be made OpenOffice compatible- - they claim to do Excel 2000 VBA code, and my code certainly is compatible with Excel 2000, so maybe it's just some minor things that need to be tweaked.

shrek_fx · #6 02-22-2008, 01:25 PM

That would be awsome.. I just dont think its write to go out and pay big bucks on a program that you can actualy get for free, well a similar program.. Can you get the older microsoft offices for free?? I have no idea?

shrek_fx · #7 02-24-2008, 12:02 PM

O.k. if ound me a copy of Mico office that has exel. and it works.. my question, again i read that thread and know how to do it all. when i make the macro, does it replace the heal macros i have on my player bar? or where will i see these macros... and is there away with this set up to make combo macros.. like for me being a ranger, do stealth type shot, then do my hidden bow shot? or something like that. or will have to set up these macros in game? Hope i dont sound to confusing

**gm9** · #8 02-24-2008, 01:56 PM

I also gave OpenOffice a shot. They don't even support the simplest of VBA functions it seems to I am currently unable to make this compatible. On the other hand, I got my hands on an Excel 2007 and that works fine as well.

Regarding the macro configurator, this is for the little buttons [1]-[5] on group and raid window. You can add custom commands as well so anything is possible.

rainmare · #9 02-25-2008, 02:10 PM

How do I get it to work with an AA spell? I've been trying to add Cure Spells, the paladin AA cure and when I attempt to use it, I get '/useabilityonplayer:'player.target' could not be found in your group or raid.

the edit I did on the file is as follows:

<Data Name="Button4" Macro="useabilityonplayer Player.Target Cure Spells" Tooltip="Cure Spells"/>

**gm9** · #10 02-25-2008, 03:12 PM

Quote:

Originally Posted by rainmare

How do I get it to work with an AA spell? I've been trying to add Cure Spells, the paladin AA cure and when I attempt to use it, I get '/useabilityonplayer:'player.target' could not be found in your group or raid.

the edit I did on the file is as follows:

<Data Name="Button4" Macro="useabilityonplayer Player.Target Cure Spells" Tooltip="Cure Spells"/>

Parent.Target, not Player.Target.

Omega7dt · #11 02-26-2008, 08:32 AM

I still get a - compile error in hidden module: SpellTable message using Excel 2007

**gm9** · #12 02-26-2008, 09:22 AM

Quote:

Originally Posted by Omega7dt

I still get a - compile error in hidden module: SpellTable message using Excel 2007

Strange since I tested this with Excel 2007 on Windows XP this weekend and it worked fine.

I think the previous poster that reported this said it happended when he clicked save. Can you tell me exactly what you were doing when you got the error? Including the spell you selected, any filters you may have applied, the button you selected?

Omega7dt · #13 02-26-2008, 04:24 PM

I download and extract the file; I open it it has a security warning pop up saying some active content has been disabled. I click options and I enable macros and active x. My main is a guardian so I go down to spell Sentry Watch (1600) and as soon as I click to save the selected spell line to Profit UI I get the error.

Omega7dt · #14 03-12-2008, 08:07 AM

I have switched back to Windows XP and now this works for me.

**gm9** · #15 03-12-2008, 08:16 AM

Thanks for the info. So you were on Vista before? I'll just mark Vista as incompatible until further notice then, probably some security feature thereof...

Kaldran · #16 03-12-2008, 11:54 AM

Well since I use OpenOffice I can't recreate this. If this happens on Vista while trying to create the UI files in \program files, just run Excel as administrator (or get EQ2 out of \program files, will save you a lot of trouble :P ).

**gm9** · #17 03-12-2008, 11:59 AM

Quote:

Originally Posted by Kaldran

Well since I use OpenOffice I can't recreate this. If this happens on Vista while trying to create the UI files in \program files, just run Excel as administrator (or get EQ2 out of \program files, will save you a lot of trouble :P ).

I don't think that's it, the VBA code does not try to access any files before you hit the save button, but some people reported an issue with compiling the SpellTable code before they ever get to save, at least that's what I understood. And that code in SpellTable does nothing of this sort. I'll try changing that code around a bit for the next release.

In any case I should probably port this to a standalone app. Feeling bored Kaldran?

I definitively don't have the time atm...

Kaldran · #18 03-12-2008, 12:59 PM

Quote:

Originally Posted by gm9

I don't think that's it, the VBA code does not try to access any files before you hit the save button, but everybody reported an issue with compiling the SpellTable code so far, which does nothing of this sort. I'll try changing that code around a bit for the next release.

In any case I should probably port this to a standalone app. Feeling bored Kaldran?

I definitively don't have the time atm...

If you have the data in a parseable format and tell me what to do with it, maybe :P (I have not looked into it yet). Need to start my master thesis by the end of this month though, so I will get short in time again soon....

**gm9** · #19 03-12-2008, 01:30 PM

In that case you should rather get that thesis going I'd say.

Kaldran · #20 03-12-2008, 01:36 PM

Don't even have a topic yet :P So I _do_ have another 1 or 2 weeks to do something else :P I was already thinking about making that a plugin for the updater, just did not start crawling through that excel sheet yet. It would be able to run standalone without any (bigger) changes too...

**gm9** · #21 03-12-2008, 02:27 PM

Let me make an update to it first, after that I'll dump a .csv with only the necessary data and the source code to you. Personally I was thinking of using VB, that would allow lazy me to just drop most of the VBA right in I think.

But if you want to do it in Java that's fine too.

Airon · #22 03-17-2008, 10:59 AM

Same thing that has been mentioned above

Word 2007
Windows Vista Ultimate
Dirge class
Gravitas spell

Mareid · #23 04-05-2008, 04:58 AM

My comp crashed, bought a new one, had to take it with Vista

. I usually use open office, but I know that doesn't support VBA, so I downloaded the 60 day full version of MS Office (note that if you use the "trial" version that comes with your computer, you won't be able to configure the security stuff, you really need the full version) and tried running the configurator code. It is definitely Vista/2007 Excel related. If it's a security feature, I couldn't find it, I turned off all the security features and I am still getting the compile error.

pollack · #24 05-09-2008, 01:38 PM

similar to those stated above, however my error reads

Compile error in hidden module: QMBCform

any ideas?

**gm9** · #25 05-09-2008, 02:39 PM

Nope, none, I don't know any people crazy enough to use Vista so I can't go and debug it on one to find out what's wrong.

I did convert the spell table database into SQL a while ago with an intention of creating a standalone configurator program, but I have not yet started with the coding and my current work schedule won't allow me to start with this anytime soon. Same reason why interface development is pretty much on hold atm.