Skip to content

You are not logged in. Register orLog In

start:

Macros
Prev   Next
General
Where can I find help on writing macros ?
Is OpenOffice.org's macro language the same as MSOffice ?
How can I record a macro ?
How can I assign a macro to a key ?
How can I make a macro globally accessible ?
HOWTOs and Documentation
Where can I find more info ?

The email address is the best email address as the API project is the place where most macro experts would reside.

No, it is not the same. But the language itself is very similar. However the security model is different as is the model of how the document is structured.

Go to “Tools” => “Macros” => “Record Macro”, then press the sequence of keystrokes you want. Then click on "Stop Recording". On the new window that pops up, save the file under “soffice>Standard>Module1” and give it a relevant name.

Go to “Tools” => “Macros” => “Macro...”, then select the macro you just made, then click "Assign".

Under the "Keyboard" tab select some unused key for this action, like F3 for instance.

Click on "Modify", then "OK" then "Close".

Now F3 will do exactly what you wanted, with only one keystroke. Because you saved it under "soffice", this will be available in all your OpenOffice documents.

(From Andrew Pitonyak:) Add it to an application level library object!

Create a library at the application level. After entering the Macro organizer, make certain that the library object reads soffice rather than some other document;

Create a library for your special macros. I created one named Pitonyak since I figure that I am not likely to have a conflict with that name;

Use meaningful names for the module that you create to store your macros. Do not use Standard! Don't ask me why, it is a big secret why and if I told you then I would have to go and look it up and I am too old and lazy to do that... Use meaningful names such as "CalcUtilities" or "WritingMacros" or "StuffICanNotLiveWithout".

Add the macro that interests you into this library.

    Now, you either have to manually load the library every time that you want to use it, or you need to load the library in the macro itself.

    Globalscope.BasicLibraries.loadLibrary("Pitonyak")

    So that the library is loaded and ready to go.

    More info API project and from the Developers Guide . Andrew Pitonyak has also written an excellent macros document contain many many examples : http://www.pitonyak.org/oo.php

    Prev Up Next
    Database Home | ToC Math