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,
[email protected] <mailto:[email protected]>
[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
