Page 1 of 1

Compatibility with VBA Macros

Posted: Sun Oct 18, 2009 8:27 pm
by jeremydeal
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)

Re: VBA

Posted: Sun Oct 18, 2009 8:34 pm
by TheGurkha
Go-oo is the version that has the best compatibility to VBA, as far as I understand.

Re: Compatibility with VBA Macros

Posted: Sun Oct 18, 2009 8:36 pm
by jeremydeal
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

Re: Compatibility with VBA Macros

Posted: Sun Oct 18, 2009 8:46 pm
by Villeroy
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.