A programmer who writes VBA for Excel has no other application in mind. Nobody would ever think about some other spreadsheet application trying to run that code and it is in the best interest of Microsoft that all this should to be as incompatible as possible with the rest of the world.
Expecting that any non-MS software should be able to run this code is naive. This will never happen unless someone writes an exact clone of Excel. Even the code that is "translated" in go-oo.org can not be reliable. Nothing can guarantee that the code does the same thing in 2 different applications.
Personally, I strongly recommend to stick with Excel as long as important things depend on heavy VBA scripting. This is what you get with proprietary solutions. Replacing Excel-VBA with OOo's StarBasic macros takes you from one trap into another trap with a much smaller user base.
Please, edit this topic's initial post
and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x