Calc macro workbook open

[OldManMac]

I created a workbook in Excell 2016 that runs a macro when the workbook is opened. I converted that workbook to OpenOffice 4.3.1 and it works fine. However, I recreated the workbook from scratch in OpenOffice and brought the macros from Excell into it. The macro that ran when the Excell workbook first opened is not working in the OpenOffice workbook when opened. How do I get a macro in VBA script to run when I open this new workbook? All the other macros in VBA script work as inteneded. I just need this one macro to run when the new Calc workbook opens. Please help!

[RoryOF]

Different macro language, with some slight overlap into VBA compatibility. You need to rewrite.

[OldManMac]

The converted workbook from Excell 2016 runs the VBA macro when I open it. So there is no problem with the script. I just want the new workbook to recognize that the macro should run when the new workbook opens.

[RoryOF]

Discussion and suggestion in this thread
viewtopic.php?f=20&t=34914

[Zizi64]

The converted workbook from Excell 2016 runs the VBA macro when I open it.

It is depend on the type of the macrocode. The arithmetical functions, (calculation routines) will run without any problem. But the application-controlling routines and functions are not compatible. The VBA and the API of the AOO/LO are basicly different.