Compatibility with VBA Macros

Creating a macro - Writing a Script - Using the API

Compatibility with VBA Macros

Postby jeremydeal » Sun Oct 18, 2009 8:27 pm

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)
openoffice 3.1 on vista
jeremydeal
 
Posts: 4
Joined: Sun Oct 18, 2009 3:20 pm

Re: VBA

Postby TheGurkha » Sun Oct 18, 2009 8:34 pm

Go-oo is the version that has the best compatibility to VBA, as far as I understand.
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Compatibility with VBA Macros

Postby jeremydeal » Sun Oct 18, 2009 8:36 pm

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
jeremydeal
 
Posts: 4
Joined: Sun Oct 18, 2009 3:20 pm

Re: Compatibility with VBA Macros

Postby Villeroy » Sun Oct 18, 2009 8:46 pm

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17316
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Macros and UNO API

Who is online

Users browsing this forum: sbar99920 and 8 guests