Quick Macro Button Configurator

[TimeTraveller]

Hi gm9,

first of all, thank you very much for such a great work.

i am trying your new version to modify my buttons, but nothing happens.
Excel 2002 SP 3 is telling me something about a compiling error in a hidden module: QMBCform

Even Excel 2007 will not work.

Do you know anything about it?
Or is it my fault? Read your faq, but clicking on the spells name and then the red button delivers the error message.

Thanks in advance.

TT

[gm9]

Are you on Vista? This sounds like the issue reported with Excel 2007 on Vista, but it may well affect all versions of Excel.

[TimeTraveller]

Sorry, forgot to tell you.
No, i am running on XP sp 3.

[gm9]

Hmm. Had you tried one of the previous versions before and did you have the same issue?

[TimeTraveller]

Sorry for that, but the answer is no, due to the fact, this had been my first try changing the macro buttons.

Do you have a adress to download an older version?
If needed, i will send you my e-mail per pm.
Greets,
TT

[gm9]

I don't think previous versions will change something, I just wanted to make sure. It probably has to do with SP3 for XP, maybe they changed the same thing with it that also breaks it on Vista. If I can get my hands on an XP SP3 with Office on it I'll see what I can do, and eventually I was going to make the tool into a standalone but that is even further down the line.

Until then you are probably out of luck unless you can find a different machine/OS to make the changes on, sorry.

[TimeTraveller]

Hi gm9,

tried it with openoffice 2.4 on xp sp3.
Nothing happens there, either.

Thanks for your answers.

Greetz,
TT

[gm9]

OpenOffice will not work since it is incompatible with MS Office VBA scripting.

[TimeTraveller]

Hi there,

thx for the info.

Tried it on XP SP2 with Excel 2002 SP3.

Same error message as in first post.
Do not know why, because the 2 computers have different installations.

Greetz,
TT

[riddellj]

I'm getting the same error on XP2 SP2 and Excel 2003

[gm9]

Originally Posted by riddellj

I'm getting the same error on XP2 SP2 and Excel 2003

Lol ok, XP SP2 and Excel 2003 SP3 is what I have at the office, and having no issues with it. This morning's update was written on Excel 2000 and I had recently retested on Excel 2007 without issues.

Do you guys maybe have Virus Scanners that block VBA code or something?

Grr, why did I ever have the bad idea to write this tool in MS Office VBA...

[TimeTraveller]

Hi gm9,

thx for the new version.
Short: Nope.
Long: Same error message as in first post, even with deactivated Virusscanner.
Using Antivir Premium.

Kurz gesagt, ich aktiviere das Feld mit dem Spellnamen und klicke auf den großen roten Button und das Fehlerfenster geht auf.
Muss man vlt. eine Komponente fürs Visual Basic installiert haben, die normalerweise nicht drauf ist? Kenne mich da nicht so aus.
Versuche heute Abend mal die neue Version unter XP SP3 mit Excel 2007 zum laufen zu bringen, vlt. klappt es ja da....

Greetz,
TT

[Calain80]

An other problem could be your security options for macros inside Office / Excel.

Depending on your settings no unsigned macros will be run. Even without asking / waring you that there are macros that are suppressed.

Try to check your options for macro security. Best would be to set it to medium (ask you every time).

[gm9]

No, no optional office/VBA components should be necessary for the code. Outside of office, it is calling shell32.dll, ole32.dll and on Office97 systems it would be calling VBA332.DLL as well.

When I have a moment I'll post a version without all path selection code (that's the code doing all these calls above), maybe that's what's tripping it up on your systems since Virus Scanners don't like it or something like that.

[TimeTraveller]

Macro Security is set to medium.
So, this is not the problem.

[TimeTraveller]

Ok, little update.

Had finally time to test the new version on XP SP3 with Office 2007 SP1, both up to date.

It is working...
But i do not know why.

Greetz,
TT

[TimeTraveller]

mmhh,

question:
Configuring the buttons works, spells are casted, but the groupmessage ist not send.
Anyone any ideas why?

Greetz,
TT

[TimeTraveller]

gm9,

do you have any ideas, why the groupmessage is not send in configured buttons via the macro tool?
Would like to change some with message.

Thx in advance.

TT

[gm9]

I'll have to take a look at the code, been a bit busy these days.

[TimeTraveller]

Just take your time.
I am not in any hurry.

Greetz,
TT

[Trump]

hey gm9 thx much for the work you do. one question though in the download section of the quick macro window it seems as though i should be downloading an application that is a macro setup tool...but all i seem to be getting is the .xls file and that doesnt do anything but give me errors when i try to use it. thanks in advance.

[ShadowProwler420]

Yes, the mod is simply an Excel spreadsheet that sets the macro buttons in the group and raid windows in ProfitUI. Detailed instructions can be found here (in the FAQ in gm9's portal).

Not quite sure what to say about the error(s) you get when trying to use it, but it may help to have some idea as to what the error is saying.

[Trump]

the error i'm getting is
"Compile Error in hidden module: QMBCform"
Xp pro svc pack 2
no antivirus software running and macro security set to low....

[spahnlie]

"Compile Error in hidden module: QMBCform"

Xp pro sp 2

smart doctor antivirus software running and macro security set to medium

[Trump]

so anyone have an answer as to my little compile error i'm getting? I've tried redownloading the macro config app and restarted my comp and still same thing...thanks in advance