How to bookmark anything in OpenOffice.org
Next comes the BookmarkDocument macro. OpenOffice.org Basic comes with the FilePicker service that can do the heavy lifting for you. This service displays a file picker dialog, which allows the user to select a document. To initiate and execute the service, you need only two lines of code:
Because the bookmark manager handles only word processing documents, it's a good idea to add a filter to it so the user won't be allowed to choose files in other formats, which is exactly what the With … End With code block does.
After the user has selected a file, the macro extracts the file's name. To do this, the macro uses the DisplayDirectory property to obtain the file's path and the Right and Len string routines to extract the file's name from the path.
Next, the macro establishes a connection to the BookmarkDB database and inserts the obtained file name and path in the appropriate fields in the files table with the INSERT INTO SQL statement.
The OpenDocument macro starts by establishing the connection to the BookmarkDB database and uses an SQL query to obtain all the records (bookmarks) from the files table. Then the macro calls the BookmarkDialog dialog and populates the listbox in it with the file names.
When the user selects a file from the list and presses the Open button, the macro uses the file name as part of the following query to find the appropriate record:
SQLQuery="SELECT ""FilePath"" FROM ""files"" WHERE ""FileName""=" & "'" & CurrentItemName &"'"
Finally, the macro passes the obtained file path to the Shell statement, which opens it with OpenOffice.org Writer.
One major advantage of this DIY bookmark manager is that you can tweak it any way you want. For example, you can add an input box to the BookmarkDocument macro that prompts you to enter tags for the selected document. Then you can modify the OpenDocument macro to display only bookmarks matching a specific tag.
With a few simple tweaks, the bookmark manager can be used to launch applications. In other words, with the basic bookmark manager in place, there are virtually no limits to what you can do with it.
- OpenOffice.org Bookmarks Menu extension: http://extensions.services.openoffice.org/project/bookmarksmenu
Richard Stallman calls for the W3C to remain independent of vendor interests.
The new release supports nine architectures, 73 human languages, and zero non-Free components.
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 is a grep-like, command-line tool that has been optimized for programmers to search large trees of source code.
New features in SUSE Studio 1.3 include enhanced cloud integration, VM platform support, and lifecycle management.
The Linux Foundation recently announced that the Xen Project is becoming a Linux Foundation Collaborative Project.
Open source version of LiveCode is now available for developing apps, games, and utilities for all major platforms.
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.
The new Gnome release includes privacy and sharing settings, allowing more user control over access to personal information.
Mozilla is collaborating with Samsung on a new web browser engine called Servo.