[Solved] Macros stopped working .. require jre6

[oporus]

My macros have suddenly stopped working.

OO requires a JRE to run macros and this appears to be missing. So simple ... download JRE? and put the link in. Not simple at all, surprise surprise.

There seems to be a problem with OO and jre7 ... entry points. Java want me to use jre7 and tell them why it does not work as jre6 did.

All this is too complicated ... I just need a few macros to work ... not a full time job mediating between OO and Java.

1. Why did my macros stop working
2. How do I fix it ... simple fixes only please.

Thanks

[oporus]

My macros suddenly stopped working and I get this message attached.

OO seems to have a problem with jre7. I tried downloading jre6 but went round in circles with them.

Anyone know what is going on ?

[RoryOF]

You need a 32 bin Java, which you then select in OO /Tools /Options. On the Java site the 32 bit files will be flagged i586

[FJCC]

If you are running OpenOffice version 4.1, you should not need a Java 6 version but it does need to be 32 bit.

[Villeroy]

The macros do work without any Java installed on the system. Instead of Tools>Macros>Run... use Tools>Macros>Organize>Basic>Run
When you assign some kind of event to a macro, the misleading error message pops up several time. Just cancel the message until a macro selector pops up and everything will be fine.
https://issues.apache.org/ooo/show_bug.cgi?id=86541 is one of the most absurd and disturbing office bug ever and nobody is going to fix it since years.

[oporus]

ok - pleased to say I - sort of - solved the problem, however I do not know the cause.

I reinstalled Java (7), even though Java /oracle / OO websites say there is an issue with OO and Java7 entry points, and reinstalled OO4.

I was then able to record and use macros again but all my existing macros failed - I had to re-record all of them.

No idea why this happened - no doubt an OO genius knows - don't keep it to yourself, please let us know.

[oporus]

CORRECTION

Problem not solved - now I am getting the attached error 22 times whenever I open a spreadsheet.

[Villeroy]

Something tries to call a Basic macro "graphs" in module "Module1" of library "Standard" within the "My Macros" container.

[RoryOF]

Put up a 32 bit java 6 and select it in OO's settings.

[Villeroy]

Put up a 32 bit java 6 and select it in OO's settings.

Well, this won't add Application.Standard.Module1.graphs() which would run perfectly without Java it it was there.

If you can not find out what tries to call this macro:
Tools>Macros>Organize...
edit any existing "Module1" in library "Standard" below "My Macros".
if such module does not exist, push [New...]
Change Sub Main() to Sub graphs() so the calling something finds its called routine.

[oporus]

And the real answer is ....

An OO genius has to make sure that OO4 works ok with Java7

[RoryOF]

It's your macro. Mine work OK.

[Villeroy]

It's your macro. Mine work OK.

... even with no Java on the entire system.

[oporus]

OK - still do not know why macros stopped working - but ....

If you have to re-install, remember that do a clean complete re-install you have to delete the user data (which is where macros are stored) - it does not get uninstalled automatically.

User data at :-

C:\Users\<username>\AppData\Roaming\OpenOffice>

OO now working Ok

Thanks for everyones' help.