Creating Basic Macros in OpenOffice
MASS PRODUCTION
The OpenOffice productivity suite can use a variety of scripts and macros to automate recurring tasks. The easiest approach is to use the integrated Basic dialect. This article helps you get started with this surprisingly sophisticated programming language.
If you find yourself repeating complex, multi-step tasks in OpenOffice [1], it may be time to create a macro. OpenOffice supports a variety of programming options. Version 1.1 introduced the concept of bridges, which allow users to add their own C, C++, Java, or Python programs. In version 2.0, which is due for release any time now, the basic OpenOffice package will also support the Common Language Interface (CLI), which allows users to add their own Javascript and C# programs. Of all the languages used with OpenOffice, Basic is perhaps the easiest option. This article describes how to get started with creating macros in Basic. Getting Started Basic programming starts in the Tools | Macros menu, which has two entries: Record macro, a macro recorder for interactive use, and Macro..., which opens a new window (Figure 1).
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
US / Canada
UK / Australia
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Find SysAdmin Jobs
News
-
Orange Pi Board Has Arch-based Linux Distribution in the Works
The developers of the Orange Pi board are planning to release an Arch-based Linux distribution available for its hardware as an alternative to Orange Pi OS.
-
Alpine Linux 3.17 Now Available to the General Public
The developers of Alpine Linux have officially announced the release of the latest version of the security-focused Linux distribution.
-
The New StarFighter Linux Laptop Now Available for Preorder
A new, completely customizable Linux laptop is now available to preorder from Star Labs.
-
Critical Escalation Vulnerability Found in the Linux Kernel
A new local privilege escalation vulnerability has been discovered in the Linux kernel and users are encouraged to upgrade/patch immediately.
-
AlmaLinux 8.7 Now Available
The developers of AlmaLinux have released the latest version of the OS, named Stone Smilodon, to the general public.
-
New Arch-Based Linux Distribution Aims to be Beginner-Friendly
CachyOS has been created to serve as a Linux distribution for everyone, even while being based on the more complex Arch Linux.
-
elementary OS 7 Getting Closer to Release
The team behind elementary OS has announced they are now focused on putting the finishing touches on the next major release of the Linux distribution.
-
Nitrux 2.5 Released with Kernel 6.0 and KDE Plasma 5.26
Nitrux 2.5 has been officially released and is the first systemd-free distribution to include both kernel 6.0 and KDE Plasma 5.26.
-
Zorin OS 16.02 Now Available
Zorin OS 16.2 has been officially released just seven months after the first point release of the user-friendly Linux operating system.
-
Linus Torvalds Considers Dropping i486 Support
In a message to the Linux kernel mailing list, creator Linus Torvalds indicates that it's time to jettison support for i486 machines in with Linux kernel.