Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi Andrew,

The link that Tom refers to lead me to several documents of which only one deals with what I want 
to do (which is install a macro that is global to openoffice/libreoffice). That would be 
location=share and on Windows the path would be %PROGRAMFILES%\libreoffice 4.0\share\basic\.

From the LO/OO GUI I can't create any NEW macros within the "global container" (grayed out). And I 
haven't found any option to enable it. So there's obviously some kind of security reason that I 
don't know how to circumvent.

The only document within Tom's links that should do what I want is the following:

"To Make a Custom Basic Library Available to All Users on a Network"

The basic idea of this guide is to create my macros within my "user profile folder" and then copy 
them to the "global share folder". However, note how the guide suggests to include in script.xlc 
and dialog.xlc: the library xlink:href should point to $(USER)/basic...etc.
I find that wrong (or not what I want).
I understand that $(USER) points to the user profile folder where I first wrote my macros. It 
doesn't point to the "global share folder". So maybe it does make the macros available in OO/LO on 
that PC as "global macros" BUT it is required to keep a copy of the macros in the $USER dir. Am I 

What I would like to do (or at least that's what I feel should be done) is not to COPY the macros 
from a user dir to the global share dir but to MOVE them. So if I do that then the library 
xlink:href in script.xlc and dialog.xlc should point to something like 
"$(INST)/share/basic/MyLibraryName/script.xlb/". Doing so doesn't make LO or OO complain BUT I 
don't see my library listed in the "gloabl macros tree mode". So I can't run my macros in the 
"global share".

As I stated in another e-mail on this list, I managed to actually install my custom BASIC macros 
within the "global share" by creating my own extension .oxt file. So I'd be happy with that except 
for the fact that I can't also bundle my JAVA macros in my extension oxt file. So I'm stuck in the 
middle: I can install my Java macros by copying them over to the global share (and they work!) but 
I can0t do the same with Basic macros; and on the other hand I can deploy my Basic macros with a 
custom extension but not my Java macros. I can combine both methods to do what I need (ie. "install 
custom Basic and Java macros in the global share") but that doesn't sound "clean" or efficient.

Any more ideas?



--- On Thu, 6/13/13, Andrew Douglas Pitonyak <> wrote:

Openoffice stores individual macros
in modules. Modules are stored in libraries, and libraries
are stored in macro containers.

Three "things" can be macro containers, documents, your user
space, and one that is global to OpenOffice. It sounds like
you desire to add a macro that is global to OpenOffice. I
have never done this.... It is not enabled on my Linux
system, is it available to you to do from the GUI when you
are logged in as an administrator?

I expect that the Link from Tom Davis is the best you can
find, since I don't see an ability to set the Macro location
directories in the configuration.

On 06/12/2013 02:26 AM, Vieri wrote:

This is probably trivial but I'm not capable of
correctly creating new custom macros within
%PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7).

My goal is to setup some custom macros globally for all
users (location=share). I don't want to include the macros
within location=document because I'll be deploying lots of
docs and it would be a pain to maintain/update macros within
every single odt document. I'd also like to avoid
location=user (or location=application - I don't remember
which is which) because I have PCs that are being used by
lots of users and copying/syncing "user macros" to each user
profile on every machine would be a waste of space and
network bandwidth.
That's why I was hoping to install and update all my
macros within the main LO application.
Another even better way would be to tell the LO
application that my custom macros can be found on a remote
server, eg. something like "location=url". This way, I'd
maintain my macros on my web/ftp/webdav/whatever server
(just one single copy) and forget about syncing them with
each and every LO client installation.

Any ideas?


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.