[Solved] Can OpenOffice load .XLSM files from Excel

[kafka]

My old computer died recently and I have ordered a new one. I have a number of Excel files which I would like to use in OpenOffice (rather than buying Office) but I would like to be able to open my Excel files, including macro enabled files in OpenOffice, without having to recreate those files. I run macros in these files by pressing macro buttons with I have created.

[FJCC]

OpenOffice may open the files but it won't run Excel macros. You could try LibreOffice, which has somewhat better macro compatibility with Excel, but I'm doubtful the macros will work with no changes. The APIs for Excel and the other programs are very different and code translation is difficult.

[kafka]

Thank you. I may have to redo the macros.

[Zizi64]

I may have to redo the macros.

The custom calculations in the custom Cell functions created for the Excel will work (mostly) in the Calc. (Some of them request some modifications.)
But you must rewrite the macros that control the cell formats/styles, and other properties of the Sheets and the Spreadsheet (and other type of) documents.

[karolus]

As
@mikekaganski in your crosspost on ask.libreoffice has already told, LibreOffice has a slightly better compatibility especially with VBA.
And yes, Crossposting is ok, but crossposting with no link to each other is considert as rude