Converting macros from MS Excel to OpenOffice.org

Discuss the spreadsheet application

Converting macros from MS Excel to OpenOffice.org

Postby JFC » Thu May 15, 2008 5:22 pm

Dear all:
I´m a user of Microsoft Excel and I got a spreadsheet wiht some macros. Pls, how can I do in order to convert my MS macros into Open Office??
Thanks a lot
JFc
JFC
 
Posts: 1
Joined: Thu May 15, 2008 4:55 pm

Re: CONVERTING MACROS FROM EXCEL MS TO OPEN OFFICE

Postby Villeroy » Thu May 15, 2008 5:40 pm

Simply rewrite them.
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: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Converting macros from MS Excel to OpenOffice.org

Postby Hagar Delest » Fri May 23, 2008 11:04 am

AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28951
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Converting macros from MS Excel to OpenOffice.org

Postby kingfisher » Fri May 23, 2008 11:41 am

There is a service designed to assist conversion but I've never used it. If you want some other references and sources, you could look at my notes.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: Converting macros from MS Excel to OpenOffice.org

Postby Villeroy » Fri May 23, 2008 12:07 pm

The problem as I see it is that there are literally millions of VBA routines out there, some of the better ones have been distributed as add-ins with buttons, menus, dialogs and all kinds of references to other code (ActiveX). Many of the VBA-questions in this forum come from non-programmers who expect that VBA can be started just like their xls documents can be loaded.
I tried to explain the difference between documents and macros using a loose analogy of punch-tape driven looms creating different carpets: viewtopic.php?f=9&t=5142&p=24051&hilit=loom#p24051
:oops: :lol:
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: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests