Is there a version that will work with VBA in a .xls file? My spreadsheet buttons will not work with macros enabled.
Also I downloaded go-oo that said VBA macros will work alas they did not.
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases your chances of a reply. (TheGurkha, Moderator)
Compatibility with VBA Macros
-
- Posts: 4
- Joined: Sun Oct 18, 2009 3:20 pm
Compatibility with VBA Macros
openoffice 3.1 on vista
Re: VBA
Go-oo is the version that has the best compatibility to VBA, as far as I understand.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
-
- Posts: 4
- Joined: Sun Oct 18, 2009 3:20 pm
Re: Compatibility with VBA Macros
well it did appear to run but it said there was a error a code editor seemed to show up but I wasnt sure. Unfortunatly it runs correctly in MS excel
openoffice 3.1 on vista
Re: Compatibility with VBA Macros
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.
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice