Ask Your Question
0

Error message when I open spreadsheet on other computer

asked 2017-12-04 18:56:06 +0100

digifoss gravatar image

updated 2017-12-05 10:04:10 +0100

pierre-yves samyn gravatar image

I have been working on a Calc spreadsheet with macros at home and emailed it to myself so I can work on it at the office. The spreadsheet opens at the office no problem, but when I press a button on the sheet to run one of the macros, I get the following error message and the macro doesn't load:

A Scripting Framework error occurred while running the Basic script vnd.sun.star.script:Standard.Module1.start_form?language=Basic&location=application.

Message: The following Basic script could not be found:
library: 'Standard'
module: 'Module1'
method: 'start_form'
location: 'application'

when I open the macro editor, there are no macros in Module1

Pardon my ignorance, I am pretty green with LO Basic....

edit retag flag offensive close merge delete

Comments

You most probably have stored your macros not to the file, but to local store, so that it doesn't get moved with the file.

Mike Kaganski gravatar imageMike Kaganski ( 2017-12-04 18:59:25 +0100 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2017-12-05 10:02:38 +0100

pierre-yves samyn gravatar image

Hi

You can move dialogs with ToolsMacrosOrganize Dialogs. Unfold source & target then drag & drop.

For example, in this screenshot I move Dialog1 from Standard to Untitled.ods

image description

Note: add Ctrl if you want to copy

Regards

edit flag offensive delete link more
1

answered 2017-12-04 23:32:52 +0100

peterwt gravatar image

If you want to run a document with macros on a different PC to the one you created the document on then you should put the macros in a module placed in the document. If you have the macros saved in MyMacros on the PC you created them on they will not be on any other PC. By default macros are saved in the MyMacros.

edit flag offensive delete link more

Comments

I am still confused. When I created the macros, I assumed I was working in a macro stored in the document. I didn't make any choises to store it elsewhere, I just opened the macro editor and edited, then hit the save button when done. So, is there an option somewhere that I need to select to store modules in the document ?

digifoss gravatar imagedigifoss ( 2017-12-05 03:04:29 +0100 )edit

So I have added a new module attached to the spreadsheet and copied the macro code from the module in MyMacros. Now I need to move my two dialogs that also reside in MyMacros to the one attached to the document. How do I move or copy the dialogs ?

digifoss gravatar imagedigifoss ( 2017-12-05 05:05:55 +0100 )edit

Thanks for all the updates, that answers my questions. Ill mark this answered.

digifoss gravatar imagedigifoss ( 2017-12-05 16:25:46 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-04 18:56:06 +0100

Seen: 206 times

Last updated: Dec 05 '17