Moving a macro to another computer

Discuss the spreadsheet application
Post Reply
djd
Posts: 18
Joined: Tue May 20, 2008 1:25 am

Moving a macro to another computer

Post by djd »

Is there a way to copy a macro written on one computer to a version of openoffice calc on another computer?

Thanks
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Moving a macro to another computer

Post by Villeroy »

Put your module(s) into a library that is not named "Standard".
Menu:Tools>Macros>Organize>Basic... [Organizer...]
Tab: Libraries, select your library [Export...]
[X]Export as extension, [OK]
Specify the file name. You get a zip-archive with extension ".oxt"


On the other system double-click that file or add it through Menu:Tools>Options>Extensions...
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
djd
Posts: 18
Joined: Tue May 20, 2008 1:25 am

Re: Moving a macro to another computer

Post by djd »

Thanks for your help
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: Moving a macro to another computer

Post by kingfisher »

One method is to use the Macros editor. There is an icon in the tool-bar to export a module to a text file (extension .bas) and another to import such a file.
Apache OpenOffice 4.1.9 on Linux
Post Reply