[api-dev] Open Office VBA porting? or leave as it is?
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. A lot of effort in this project has been put into cross-platform compatibility (windows and os x). Not having real programming knowledge VBA and excel seemed to be the right solution for my parents: And it really works fine: the possibility to have the spreadsheet functionality combined with the easy to learn VBA worked quite long. But now mikrosoft has announced to cease support for VBA and any automation on os x. So Excel won't be the 'development platform' for my parents in the future and a new solution has to be found. I'd like to port their tax software to open office to be able to develop with java (I'm still trying to get the sdk working with eclipse as you can see in my other post..) But I won't have time for porting it all and supporting them all the time. It would be mandatory that my parents could script some basic solutions themselves - and learning java is not a possibility of theirs.. now the nicest solutions for us all would be to doubleclick the .xls file and run vba in open office, which surprisingly doesn't work ;) Nevertheless I'd like to give it a try.. The explanations on http://wiki.services.openoffice.org/wiki/VBA are somehow cryptic and the vba mailing lists far from being active. 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? thanks for your suggestions! Simon - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] Open Office VBA porting? or leave as it is?
Hi Simon, Simon B. Margulies wrote: [...] What do you think? Are there any developers using VBA in Open Office? I can hardly imagine, because ... Is VBA supported in openoffice for windows AND os x? ... it is only partly supported in the Novell OOo-version and a bit more supported with StarOffice Professional Tools (and if I don't mistake, thats not yet for Mac). Should all be ported to some other scripting language? That is what I do most often with VBA code. Part can be re-used and some smart things can be done to reduce the work. HTH, Kindest regards, Cor -- Cor Nouws Arnhem - Netherlands nl.OpenOffice.org - marketing contact - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] Open Office VBA porting? or leave as it is?
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]
Re: [api-dev] Open Office VBA porting? or leave as it is?
Cor Nouws wrote: [...] That is what I do most often with VBA code. [...] Andrew's mail made me remember I didn't mention the scripting language I convert to. That is OOo/StarOffice Basic. -- Cor Nouws Arnhem - Netherlands nl.OpenOffice.org - marketing contact - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] Open Office VBA porting? or leave as it is?
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. 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]
Re: [api-dev] Open Office VBA porting? or leave as it is?
Simon B. Margulies wrote: thanks for your answers! You're welcome! I'm now looking into porting the existing vba-code to StarBasic - Andrew Pitonyak provides a lot of info (see his footer); - there's the OOoForum.org; - the Wiki : http://wiki.services.openoffice.org/wiki/Extensions_development_basic ; and ... this list ;-) Regards, Cor -- Cor Nouws Arnhem - Netherlands nl.OpenOffice.org - marketing contact - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] Open Office VBA porting? or leave as it is?
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]
Re: [api-dev] Open Office VBA porting? or leave as it is?
I started this a few years back (so it is dated and incomplete), but it might be useful. I think that on the hosting web page, there are better links, but I threw this up just because I had it sitting around. http://www.pitonyak.org/OOoBasicVBCompare.pdf 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. 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] -- 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]