OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[solved] How to attach a macro module to a calc file

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
Tiksu
General User
General User


Joined: 31 Dec 2010
Posts: 48

PostPosted: Mon Jan 10, 2011 12:07 am    Post subject: [solved] How to attach a macro module to a calc file Reply with quote

Now, when i got my macro running, i would like to attach the macro module to the calc file that it is related to. When i tested the calc file on another computer the macros were disappeared and i needed to install them manually from a normal text file.

The macros reside on my computer in My macros - Standard - myMacroFile1.

How could i get them copied and saved along with the calc file that they are intended to run on?

Tiksu


Last edited by Tiksu on Wed Jan 12, 2011 12:48 am; edited 1 time in total
Back to top
View user's profile Send private message
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Mon Jan 10, 2011 12:33 am    Post subject: Re: How to attach a macro module to a calc file Reply with quote

Tiksu wrote:
How could i get them copied and saved along with the calc file that they are intended to run on?

Take a closer look "Tools" > "Macros" > "Organize Macros" > "OpenOffice.org Basic...". There in the dialog you'll find thre possible locations for storing macros:
+ My Macros: This is the place you are using. These macros reside in your OOo profile.
+ OpenOffice.org Macros: Macros delivered with OOo. These macros reside in the OOo installation folder.
+ DOCUMENT NAME: Location for macros in a document. Use this.
Back to top
View user's profile Send private message
Tiksu
General User
General User


Joined: 31 Dec 2010
Posts: 48

PostPosted: Wed Jan 12, 2011 12:47 am    Post subject: Reply with quote

Thank you, seems to work. And special thanks for the clarifying explanation. Now the macro file menu seems as logical.

Tiksu
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group