Mar 17, 2010, 15:32 (0 Talkback[s])
(Other stories by Sukrit Dhandhania)
"Record a macro
The simplest way to create a macro is to use OpenOffice's built-in
macro recording tool. You launch the macro recorder, run the steps
you want to be recorded in the macro, then stop the recorder.
Voilà, your macro is now ready. Let's look at how to do
this. Go to Tools>Macros>Record Macro, then press the
sequence of keystrokes you want. At the end of your sequence, click
on Stop Recording. In the new window that pops up, give the file a
name and save it. Try to come up with apt names for your macros, as
weak names will drive you nuts in the future.
"Run your saved macro
Once you have saved a macro in OpenOffice, it's quite simple to run
it. Go to Tools>Macros>Run Macro. A window will pop up with a
list of all the macros available, the ones from the OpenOffice.org
team, as well as the ones created by you. Select the macro you want
to execute and hit Run. The macro will execute. Errors, if any,
will be displayed in a pop-up notification window.
If you create a macro that you want to share with other users of
the OpenOffice suite, there are two ways for you to do that. You
can either share the code used by the macro, or you can package the
macro into an 'extension' and then share it via email or put it up
for download. The second method is usually the better approach.
Let's look at how to package an OpenOffice macro into an