Macro MS Excel vs OOCalc macro

[yulB]

Bonjour. Je ne suis pas familier avec les sites d'entraide, excusez mon incursion (je suis une personne âgée .
J'essais de me convertir vers Linux avec mon PC, misérable je n'ai pas réussi j'ai tout planté et dû tout réinstaller en 1 semaine bref...

J'ai une série de fichier EXCEL écrits il ya quelques années avant ma retraite, j'en aurais besoin et voulant me FAMILIARISER avec OpenOffice j'ai essayé de les utiliser car je veux quitter le Mcrobesoft (mon jugement). MALHEUR aucune macro EXCEL n'est fonctionnelle (j'en ai pas moins de 243).
Je crois que peut-être mon message est redondant, y-a-t'il moyen de convertir sans tout réécrire?

YulB

[robleyd]

This is the English language forum - if you wish to converse in French please use https://forum.openoffice.org/fr/forum/

Translation:
Hello. I am not familiar with self-help sites, excuse my incursion (I am an elderly person .
I am trying to convert to Linux with my PC, miserable I did not succeed I crashed everything and had to reinstall everything in 1 week in short...

I have a series of EXCEL files written a few years ago before my retirement, I would need them and wanting to FAMILIARIZE myself with OpenOffice I tried to use them because I want to leave Mcrobesoft (my judgment). UNFORTUNATELY no EXCEL macro is functional (I have no less than 243).
I think that perhaps my message is redundant, is there a way to convert without rewriting everything?

[Zizi64]

Try the LibreOffice. It has a littlebit higher compatibility with the MS Office things than the Apache OpenOffice has.
If you send some of your macro code here, then we will able to say: it will run in LO or not.
And yes: it is better to rewrite your macro based on the Open/LibreOffice API. (API: Application Programming Interface.)

[Mountaineer]

For LibreOffice there are two layers of this:

At first there is a setting to ignore VBA-macros:
https://help.libreoffice.org/latest/lo/ ... pport.html

After assuring the macro is loaded one can try to test, if the setting also mentioned in the link above VBASUPPORT is enough the get the macro to run. But don't expect much. While both use BASIC the API to find out and do things are quite different....