Ask Your Question

How to copy macro libraries between odb's

asked 2021-04-07 05:58:20 +0200

gkick gravatar image


Is there a way to copy macro libraries from one to another database. Never figured out the Import feature in the dialog. Recreating and copying tons of subs can be a bit of a pain though. Thanks for any pointers

edit retag flag offensive close merge delete


Have you tried to go to LibreOffice Basic Library Organizer and just drag and drop modules along the tree from one library to another? Try it. Just don't save the original file after that to keep the library in it as well.

JohnSUN gravatar imageJohnSUN ( 2021-04-07 08:38:13 +0200 )edit

@JohnSUN, thanks for that, I did drag n drop once with dialogs and must have saved everything because the original dialog was gone.

gkick gravatar imagegkick ( 2021-04-07 08:52:35 +0200 )edit

Yes, saved it in vain. No problem - just drag it back, but this time do not save the file from which the dialog was taken. (you can try to drag with the Ctrl key pressed, but for me it causes the office crash)

JohnSUN gravatar imageJohnSUN ( 2021-04-07 09:05:04 +0200 )edit

@JohnSUN yep ctrl sends me crashing as well, just drag,outline moves but does not duplicate, guess its LO 7 still very buggy.

gkick gravatar imagegkick ( 2021-04-07 10:41:30 +0200 )edit

Not "very", just "slightly" :-) It is this error that most likely appeared recently (I saw it only today, before dragging from Ctrl worked well), you need to write a bug report. Can you?

JohnSUN gravatar imageJohnSUN ( 2021-04-07 11:13:54 +0200 )edit

Will do, they have not responded to my last one yet

gkick gravatar imagegkick ( 2021-04-07 11:23:19 +0200 )edit

Oh, give them some time. My bug was closed for seven years

JohnSUN gravatar imageJohnSUN ( 2021-04-07 11:32:14 +0200 )edit

By the way, you can try to do this in OpenOffice - there Ctrl+drag works well

JohnSUN gravatar imageJohnSUN ( 2021-04-07 11:40:38 +0200 )edit


Using Library Organizer on the Library tab, have no problem exporting any library (Standard not included) as Basic then importing that into another Base file.

Ratslinger gravatar imageRatslinger ( 2021-04-07 22:31:34 +0200 )edit

Ahh @Ratslinger - so its some sort of detour = export to some file and then import that file ? And Standard is Standard in MyMacros or the other Standard?

gkick gravatar imagegkick ( 2021-04-07 23:08:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-04-07 23:39:14 +0200

Ratslinger gravatar image


To complete the answer, from comments:

Using Library Organizer on the Library tab, have no problem exporting any library (Standard not included) as Basic then importing that into another Base file.

Any Standard library. Don't know why you cannot export from there. Yes it is a file for basic and/or dialogs. Have used these methods in past (and some tests today) to move code via Basic library or even as extension. Also note there is functionality in Basic IDE. Menu File has import/export capabilities.

And as for not using Standard libraries, I use them all the time. This is the one library which does not need loading before use. You can export these routines through the IDE as noted. Will be in smaller chunks.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-04-07 05:58:20 +0200

Seen: 28 times

Last updated: Apr 07