Moving a macro to another computer

Discuss the spreadsheet application

Moving a macro to another computer

Postby djd » Tue May 20, 2008 1:30 am

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

Thanks
djd
 
Posts: 18
Joined: Tue May 20, 2008 1:25 am

Re: Moving a macro to another computer

Postby Villeroy » Tue May 20, 2008 1:38 am

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28668
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Moving a macro to another computer

Postby djd » Tue May 20, 2008 3:07 am

Thanks for your help
djd
 
Posts: 18
Joined: Tue May 20, 2008 1:25 am

Re: Moving a macro to another computer

Postby kingfisher » Tue May 20, 2008 5:31 am

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.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests