A little shaky on adding macros

[praedor]

I've downloaded some macros from the www.oomacros.org site. Some of them conveniently come with installers, making it quite easy, but others do not - even lacking any instructions as to how to install them manually.

One such macro is the LeastSquaresFitting.sxc macro. It simply contains an "example" page and a page describing how least squares works. It says nothing about installing the macro.

I have attempted to install it thus (OOo 2.0.2):

Menu bar - Tools -> Macros -> Organize macros -> Openoffice.org Basic -> Libraries ->
and then attempting to append the thing to My macros. One of the problems with many of these macros is they contain a "Standard" library...but OOo already has a Standard library so I inevitably have to decide whether to overwrite the extant library with the new one. I always answer "no" because that just seems loonie.

How does one install macros such as the LeastSquaresFitting macro when it lacks any instructions or install macro AND contains a "Standard" lib that conflicts with the already existing one that OOo comes with?

[noranthon]

The document has to be open to do this.

The easiest method is to select the first macro in the library and click on edit. Copy the entire contents of each module and paste it to a new module in the library where you want the macro. It may suit you to save each module as a text document (extension .bas) by using the icon at the far right of the lower toolbar in the editor. You can then open the target library and copy and paste from your text documents.

Alternatively, you could create a new library in the document and cut/copy and paste from the old library to the new, then append the new library, which would have a distinctive name. I cannot find any way to rename a library in a document. Such a device would simplify matters.

[JohnV]

Perhaps this will help.
http://www.oooforum.org/forum/viewtopic.phtml?t=7995