Scripting Framework error with Basic script

[Arun P. Pai]

Dear Friends,

How are you all, I am back after a long time.

Downloaded the lastest version of Apache_OpenOffice_4.1.7_Win_x86_install_en-US.

Using Window Os Windows 6.3 (Build 9600) Windows 8.1 Single Version.

I do not have MS office at home but have to open Excel or Word files received from others.
Sometimes I write small Macros to automate repeated tasks, but not all work to my expectations.
But I love the Basic in OOo though it is tough and it differs a lot from VB used in Excel.

The following Error Screen appears when I open an spread sheet file. (ods)

Open Office Error.
A Scripting Framework error occurred while running Basic script vnd.sun.star.script:Standard.GoHome.GoHome?
language=Basic&location=application.

Message: The following Basic Script could not be found:
library: 'Standard'
module: 'GoHome'
method: 'GoHome'
location: 'application'

Is this due to a Macro named GoHome residing in the Library?

How to solve this?

Please help.

Thanking you all in advance.

Have a nice day.

Arun.

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).

[RusselB]

I'm far from an expert on macros, but it looks to me like you have a problem with that macro or that you have a macro that is saved, but incomplete.
Have you used this macro previously? If so, what was the last version of OpenOffice that the macro worked on?
I'm not aware of any changes to the macro programming for OpenOffice 4.1.7, but I'm not going to say there weren't any.

If this macro is one that you wrote, then one of the other helpers that's more familiar with macros might be willing to look it over.
Uploading/attaching a copy of your macro would be helpful for any that do want to look at it to see if they can spot any problems.

If you go to Tools -> Macros -> Organize, you'll see a small list of the macro languages that OpenOffice works with. If you can find the macro in one of those lists, then you should be able to disable it until such time as the problem with the macro can be resolved.

[JeJe]

Go to Tools menu/macros/organise macros/Openoffice basic
In the dialog that pops up go to MyMacros in the left hand listbox Standard library.

That is where your spreadsheet is expecting a macro called Gohome to be in a module called goHome.

You can stop the error by putting one there - it can be an empty one that does nothing - create a module called GoHome and put this there.

Sub GoHome
End sub

Or find the original sub and put it there.

Alternatively you can look for the place that calls the macro. Go to Tools/customise/events and see if that macro is assigned to the Open document event. As its a spreadsheet macros can also be assigned to sheet events (right click on the sheet tab). If your document has macros do a search in the IDE for one that calls "GoHome". Controls like buttons in your document can also be assigned macros.
Edit: and then delete the call to the macro GoHome as its no longer available. (didn't make that clear)

[John_Ha]

AOO cannot find your macro.

See [Tutorial] How to record a macro (and Regular Expressions) for where macros are located. Don't forget macros can be saved to the PC for use in any document; or saved to a document for use in that document only.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.

[Arun P. Pai]

Dear Friends,

Thank you very much.

Sorry the caption in the Subject should have specifically mentioned the problem. Next time will do it right.

Dear John - Problem is not solved need some time to check it out.

Dear RusselB

Have you used this macro previously?
If you go to Tools -> Macros -> Organize, you'll see a small list of the macro languages that OpenOffice works with.

Did a check did not find any such Macro. In any case deleted all Macros.

Dear Jele

You can stop the error by putting one there - it can be an empty one that does nothing - create a module called GoHome and put this there.

Did a check and deleted all Macros.

As its a spreadsheet macros can also be assigned to sheet events (right click on the sheet tab). If your document has macros do a search in the IDE for one that calls "GoHome".

Did not find such Macro assigned to sheet events.

This Scripting Framework error occurs only when I open an existing spread sheet file.
It does not occur when opening a new spread sheet file.

Yes I did write a Macro called "GoHome". The Macro will place the cursor in cell "a1" is all sheets. But that was long ago and it did not work as expected.

Today is a working day will check out again on Sunday.

Thanks a lot friends, have a nice day.

Arun.

[Zizi64]

Did not find such Macro assigned to sheet events.

This Scripting Framework error occurs only when I open an existing spread sheet file.
It does not occur when opening a new spread sheet file.

Can you upload one of the "existing spreadsheets" here?

[JeJe]

"Did a check did not find any such Macro. In any case deleted all Macros."

You don't need to delete any macros. The error is telling you it can't find that macro. You can put the macro back - or a dummy version as I suggested - and it will still look for it but there won't be an error because it will find the macro.

It looks like somewhere in your existing document, or possibly the document load event, or somewhere anyway, it calls that macro - but it doesn't exist so there's an error as it can't find it.

[Villeroy]

Example document with an embedded macro. Your macro (which no longer exists) was not embedded. Your error message indicates that your macro used to be found in "My Macros".
Either you find the calling event or you provide some dummy replacement.

[JulianR]

The error you have shown means you have a non-existent macro assigned to one of starting events of the application. Go to Tools-Customize, switch to events tab, if you see nothing, then at the bottom you will find drop-down list titled save in. Switch to Openoffice.
At one of the entries you will see something like Standard.GoHome.GoHome. Remove that and it should go away.