On 12/02/2010 01:14 PM, Barbara Duprey wrote: > On 12/2/2010 5:46 AM, modestukasai sudukas wrote: >> Hello, >> >> Our company has insurance forms. It uses VB SCRIPTS witten with MS EXCEL >> 2003. >> And we get an error when we tying to calculate. By persing on button >> (SKAIČIUOTI). >> fault nr 1.png >> >> >> Everything works perfectly on MS OFFICE SYSTEMS. What should we do? >> >> PS: if you need, we can send you this document. >> >> Than YOU, >> modestuka...@gmail.com <mailto:modestuka...@gmail.com> > > [The OP is not subscribed and probably will not see responses unless directly > copied.] > > What you've encountered is that OpenOffice.org uses a different scripting > language, not Microsoft's > Visual Basic, for macros. This can't properly be called a bug, it was a > considered design decision > -- whether for legal purposes or something else, maybe somebody else on the > list will discuss the > rationale. > > As to what you can do, I think you'll either need to translate the macros > into the OOo format, or > continue using Excel. I'm including a quote here from the OpenOffice.org > Migration Guide: > > "Macros written in VBA for Excel do not work in Calc and macros written in > StarBasic for > Calc do not run on Excel. Re-writing of macros is required when moving > spreadsheets > between either application. > Some additional resources for writing Basic macros include: > “Porting Excel/VBA to Calc/StarBasic” > http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf > StarOffice 8 Programming Guide for BASIC, > http://docs.sun.com/app/docs/doc/819-0439 > “Useful Macro Information for OpenOffice”, by Andrew Pitonyak, > http://pitonyak.org/AndrewMacro.odt > OpenOffice.org Macros Explained, by Andrew Pitonyak, > available from the publisher: http://www.hentzenwerke.com/catalog/oome.htm or > from > various online booksellers." > Andrew Pitonyak’s web site for OOo macros: http://pitonyak.org/oo.php >
I in the past I'd suggest the OP use & pay for StarOffice which has/had a enterprise VB converter. Not so sure if Oragle has maintained that. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
