Hi Simon,

Simon B. Margulies wrote:
thanks for your answers!

I'm now looking into porting the existing vba-code to StarBasic and trying to get java working for future developments.

the work on better VBA support is ongoing and probably usable for some simpler macros and maybe more complex things in the future. Anyway the API concept in OO.org is completely different than VBA. I would recommend to switch to StarBasic and or Java as soon as possible and go forward with OO.org API. You can also combine StarBasic for simple things with more complex features realized as add-on or whatever and implemented in Java. The advantage of Java is that you can use all the available Java API's as well and combine this way office functionality with interesting other stuff.

Anyway you work with Eclipse but i think you should give our NetBeans plugin a try as well. It simplifies a lot of things and helps you to get started, see http://wiki.services.openoffice.org/wiki/OpenOffice_NetBeans_Integration for more details. Well Mac OS X is currently not supported but it is planned for the next version (planned for the beginning of September).


Juergen



thanks a lot

simon




On 30.07.2007, at 22:39, Andrew Douglas Pitonyak wrote:

Simon B. Margulies wrote:
Hi all,

I'm still evaluating open office as the new solution for my parents tax software, which has been built in excel with some vba scripts.
...
What do you think? Are there any developers using VBA in Open Office?
Is VBA supported in openoffice for windows AND os x?
Should all be ported to some other scripting language?

I suspect that I do not properly understand what you are proposing. Are you proposing to continue using VBA and then use that to access OOo? This would not be very cross-platform compatible.

Using Java should be, but it has a higher learning curve and you still need to learn the OOo API. Have you considered using StarBasic included with OOo?


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to