Ask Your Question
1

How do I use ms excel macros in Calc

asked 2017-09-30 16:56:05 +0200

otto300 gravatar image

updated 2019-05-20 22:50:14 +0200

ahiijny gravatar image

I have been using MS Excel and now want to use LibreOffice (cost). Calc shows me the spreadsheets (its a junior bowling league) but I cannot "see" the macros are in the MS system. Is it and if yes, how do I get to use the original macros which are quite complicated and work well. Thanks. Gary

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-09-30 18:16:46 +0200

Jim K gravatar image

To see the macros, go to Tools -> Macros -> Organize Macros -> LibreOffice Basic. However LibreOffice Basic is not the same language as Excel VBA, and the API is very different between the two suites. So most likely you will need to rewrite the macros for LibreOffice to get them to work.

For complex macros, rewriting in Python-UNO is probably better than LibreOffice Basic. It's usually worth it to take the time to learn Python if you have only used Basic before.

Even when using Python, the resources at http://www.pitonyak.org/oo.php are still essential for learning how to write LibreOffice macros.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

3 followers

Stats

Asked: 2017-09-30 16:56:05 +0200

Seen: 9,897 times

Last updated: Sep 30 '17