How do I Write Macros in an Open Office Database?

OpenOffice Base is a free database program similiar to Microsoft Access. It is part of the OpenOffice suite of productivity software. Base has a macro utility which allows you to automate repetitive tasks, including running queries and entering information into the database. Once the macro has been created, it can be executed by clicking a button or with a series of keystrokes. You can create a macro that can be used by multiple databases or even in all of the OpenOffice software programs.

Things You'll Need

• OpenOffice Base

Instructions

1. Open the OpenOffice Base software.

2. Click on the "Tools" menu at the top of the window.

3. Choose the "Macros" option from the list provided.

4. Click the "Record" option. A small Record window will appear.

5. Execute the query or other task that you want to automate while the Record window is visible.

6. Click the "Stop Recording" button when you are finished performing the steps that you want included in the macro.

7. Type a name for the macro in the "Macro name" text box.

8. Choose whether you would like the macro to be used on all databases or only for a single database and click the "Save" button. You can now run the macro by choosing the "Run Macro" option under the "Tools" menu.

References

• OpenOffice.org: Creating a simple macro

Resources

• OpenOffice