Moving modules from one library to another, reassign macros

[Henrik]

Hi,

I have a calc document with several sheets and quite a few buttons/controls. I want to move my modules from one library to another. The problem is that I have assigned macros to all my controls and after moving the modules, the controls will all point to macros that don't exist.

At the moment a control will typically point to a macro like this:
document:StandardLibrary.ModuleA.SubA

After moving the modules to another library they should point to:
document:NewLibrary.ModuleA.SubA

Is there another way than manually reassigning all the controls?

Henrik

[DannyB]

Having played with macros just a bit myself, I can understand why you might want to do such a thing.

All OOo documents are actually ZIP files of xml. Unzip the document into a folder. It will have at a minimum....

content.xml
META-INF / manifest.xml

There will probably be other XML files. Within the content.xml you will find your buttons. Alter the macro library they point it by editing the XML text file. Then re-Zip everything back up and rename the suffix from ".zip" back to an OOo document (such as ".sxd" for Drawing, and something else for Calc).


Here's another hint. Before saving your documents, first....
Tools --> Options --> Load / Save --> General
then uncheck the box that says "Size optimization for XML". (You'll be glad you did!)


A tool that might help give you insight as to the structure of your documents is my Document Explorer, which you can get at...
http://OOoMacros.org
a direct link is here...
http://ooomacros.org/dev.php#92225
http://sourceforge.net/project/showfiles.php?group_id=87718&package_id=92225

Simply download the program. Unpack. Double click on the Jar to run the program. (Written in Java -- does not require OOo at all. OOo does not need to be running, or even be installed.) It prompts you for an OOo document. Then after you pick one, it opens a window that allows you to explore the contens of the Zip file, and the XML nodes.
_________________
Want to make OOo Drawings like the colored flower design to the left?

[Henrik]

Thx a lot DannyB