Ask Your Question
1

How to convert Macro of VBA of MS Excel to LibreOffice Calc? [closed]

asked 2014-07-10 09:28:06 +0100

IThondaJerry gravatar image

I am converting VBA macro of excel into libre office calc. how can I make this stuff

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 19:11:22.223715

Comments

I'm sure this was asked before. Could you add how your question is different from similar questions?

bencomp gravatar imagebencomp ( 2014-07-11 18:51:02 +0100 )edit

2 Answers

Sort by » oldest newest most voted
2

answered 2014-07-13 06:58:21 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

From what I have learnt ... VBA cannot be adopted into CALC.

About 12 Months ago I looked at Calc with a hope of using my Excel Addins. All my Excel 2003 addins, templates and some xls-books create temp menu-bar sub-menus when the XLA/XLT/XLS files are opened.

One addin has 63 controls on its dedicated menu. The thought of rewriting 15 years of addins and templates and the apparent bugs in Calc, turned me off.

At the time the Calc forum was full of bug reports and finding Libre coding help was impossible. My solution was to shell out for Office 2010 (the last ms-office that supports VBA) ... BUT how I hate the Excel ribbon. Although in Excel2007/2010 toolbar/ribbons are now dedicated to the file (similar to what MS-Word has been for years.)

To answer your question ... It cannot be done ... Calc does not use VBA, Libre uses a sort of visual-language. Finding help on Objects, Method, Functions, ENums etc about a year ago was impossible.

When Calc is a serious contender for Excel VBA I will have a look at Calc again.

EDIT (1 hr later)

Maybe I am wrong. See ...

http://ask.libreoffice.org/en/questio...

edit flag offensive delete link more

Comments

Also refer the answers here and here. VBA support will likely improve over time, but at present (LO v4.2-4.3) it is not great.

oweng gravatar imageoweng ( 2014-07-13 07:18:28 +0100 )edit
1

answered 2014-09-16 19:14:01 +0100

I have fairly good knowledge about VBA and did lots of works personally and professionally. I also tried macro writing in LO Calc, but man, the tutorial, materials are hard to come by.

Thus I am preparing a series of tutorials on Macro writing in LibreOffice using basic to help the entire community once and for all.

Its still work-in-progress, you can have a look here: http://www.debugpoint.com/category/pr...

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2014-07-10 09:28:06 +0100

Seen: 56,306 times

Last updated: Sep 16 '14