Automating tasks in OpenOffice
Macro Meal
© Dmitry Pichugin, Fotolia
You don't have to be an expert to get started with OpenOffice's Basic programming interface.
OpenOffice.org comes with its own Basic-based programming language. Although OOo Basic is not the most difficult programming language, it still requires some time and effort, especially if you are not a programmer. However, reading documentation and fiddling with code might not be necessary if you only need to automate a specific task now and then. In this article, I will provide a few pointers and code snippets, so you can put OOo Basic to some practical use without learning the language from scratch.
Launching External Apps
The ability to launch external applications and pass data to them is one of the most useful features of OpenOffice.org. Using the Shell command, you can launch virtually any application installed on your machine. The command has the following format: Shell (Path, Windowstyle, Parameter). Path defines the path of the program. Windowstyle defines the window in which the program is started, and Parameter specifies the command-line parameter. For example, the Shell statement below opens the http://wordnet.princeton.edu/perl/webwn URL in the Firefox browser and brings it to the foreground:
Shell ("firefox", 1, "http://wordnet.princeton.edu/perl/webwn")
[...]
Read full article as PDF »
048-051_ooauto.pdf (309.76 kB)Tag Cloud
News
-
Google and NASA Partner in Quantum Computing Project
Vendor D-Wave scores big with a sale to NASA's Quantum Intelligence Lab.
-
Mageia Project Announces Mageia 3 Linux
Many package updates and Steam integration highlight the latest from the Mandriva-based community Linux.
-
FSF Outs the World Wide Web Consortium over DRM Proposal
Richard Stallman calls for the W3C to remain independent of vendor interests.
-
Debian 7.0 Debuts
The new release supports nine architectures, 73 human languages, and zero non-Free components.
-
Alpha Version of Fedora 19 Released
Fedora developers release the first alpha version of Fedora 19, known as Schrödinger’s Cat, for general testing. The final release is expected in July 2013.
-
ack 2.0 Released
ack is a grep-like, command-line tool that has been optimized for programmers to search large trees of source code.
-
SUSE Studio 1.3 Released
New features in SUSE Studio 1.3 include enhanced cloud integration, VM platform support, and lifecycle management.
-
Xen To Become Linux Foundation Collaborative Project
The Linux Foundation recently announced that the Xen Project is becoming a Linux Foundation Collaborative Project.
-
RunRev Releases Open Source Version of LiveCode
Open source version of LiveCode is now available for developing apps, games, and utilities for all major platforms.
-
OpenDaylight Project Formed
OpenDaylight is an open source software-defined networking project committed to furthering adoption of SDN and accelerating innovation in a vendor-neutral and open environment.