Where are LO Basic macros stored?

I want to transfer to a new computer a group of recorded macros backed up intotwo files, writer.xba and calc.xba. I have recorded a writer macro in v. (in Qiana Mate), but can’t find where it is stored. Can someone tell me? I don’t need to keep the single macro already recorded in this version. Any reason why I shouldn’t just replace the new file with the old one?

The macros are grouped in modules and dialogs( =xba files). These are grouped in libraries. Which modules and dialogs belong to a library is record in script.xlb and dialog.xlb. These files together are stored in a folder. The files script.xlc and dialog xlc record, which such library folder exists. These files together with the library folders are stored in the directory “basic”. Such directory exists for the single user in its LibreOffice user directory, and common for all users in the directory “share” in the LibreOffice installation. Because of the. xlb and .xlc files you cannot simple move the .xba files around.

You can use the Organizer to administrate your macros. Find the Organizer in Tools > Macros > Organize Macros.

The Organizer can export and import whole libraries (execpt for library “standard”) in tab “Libraries”.

image description

And you can move (mouse drag) and copy (mouse drag + Ctrl) modules between libraries and documents in tab “Modules”.

image description

A single user cannot store a recorded macro into the common “Basic” directory, but he can only store it into its user directory, or he can store a macro into a module inside a document. If you have used the default settings, your macros are in the library “standard”.

To get the macros to the new computer, you can export the libraries on the old computer. That results in some folders. Copy these folders to the new computer. On the new computer import the libraries using the Organizer. To move the macros, which are inside the “Standard” library, make a dummy library “Transport” or use a document, copy the modules and dialog from “Standard” to “Transport” or to the document, and on the new computer move them from there to the new “Standard” library. Do this using the Organizer.

Find more about organizing macros in the Basic guides, and in the Books and Articles by Andrew Pitonyak.

If you never have used any own libraries you can transport macros as text files. Click on “Edit” in the Organizer to open the IDE. Click on icon “save BASIC” to write the macros to a .bas file. Copy the .bas file to the new computer. Open the IDE there and click on icon “Insert BASIC source” to read the macros.

1 Like

I appreciate your suggestions, but I suspect you are using a different version of Mint than I am (Qiana Mate). I have two modules (one for Writer macros and one for Calc macros ) in a dialog named Custom in the My Macros library. In the LO Basic Macro Organizer I have only four choices: Edit, Close, New…, and Delete. In the LO Basic Macros Organizer the only choices offered are Run, Close, Assign…, Edit, Delete, Organizer, and Help. In neither of these dialogs, nor under any of their buttons, do I find any way to export these libraries, or import anything into a module. You didn’'t explain what an IDE is, and despite usintg computers for 49 years, Ihaven’t come across that acronym.

I’d be grateful if you or someone else using v. 17 Mate can help me solve this problem.

IDE = Integrated Development Environment , see http://en.wikipedia.org/wiki/Integrated_development_environment

Find an introduction to the administrative dialogs in chapter “2. Getting Started” in “OpenOffice.org Macros Explained” by Andrew Pitonyak", http://www.pitonyak.org/OOME_3_0.pdf

I’ll add a picture of the dialog. Hopefully that will make it easier to find.