"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.
"Extensions
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 extension."
