For some reason recording of macros is one of those questions I always get during a spreadsheet class, and since i have been spending more time in Numbers lately, I thought I’d spend some time in OpenOffice. I don’t get it the question that much for Word or Writer. I do get it for Access, or Base. So I thought I would show you how to record macros in OpenOffice.
Macros in OpenOffice are rather more interesting that they are in MS Office. In Office you are limited to one language, but Open Office has exposed it’s objects to other programming languages, but we really don’t need to worry about that. If all you want it to automate some processes then the default language can be used with no worries.
To start working with Macros in the OpenOffice program open the appropriate module for which you wish to record a macro. In fact opening a file that has something that you want to record is imperative. Select the information that you want to work with and then start the record macro. This is in the tools menu >> Macros >> record macro.
When you choose record macro a new button appears on your screen. It looks something like this
Now do whatever it is that you wish to record. Then click on the stop recording button. You will see a dialog which wants to know the name of the macro and where to store it. It looks like this
Just change the name to something meaningful. Select one of the modules from the left hand list and click save. Your macros is now saved to that location. If you save to the my macros item your macro will be available everywhere. If you save the macro to the file, then it is available only in that file.
Do you use Macros in OpenOffice or MS Office? Share your experiences with use in the comments section below.
Related posts:
{ 3 trackbacks }