|Home > Forum Home > Developing and Auditing Analytical Models > Converting Excel VBA for Lotus Symphony Spreadsheets||Share|
|Forum Topic||Post Reply Login|
Converting Excel Vba For Lotus Symphony Spreadsheets
Rate this:(3/5 from 1 vote)
|In a similar fashion to NeoOffice for the Mac OS X, the multi-platform Lotus Symphony build of Open Office by IBM supports a subset of the Microsoft Excel Visual Basic for Applications library. |
The Lotus Symphony office applications include Documents, Spreadsheets and Presentations and are compatible on Windows, Linux and Macintosh operating systems.
In comparison to NeoOffice, which attempts to emulate Excel VBA when spreadsheets are opened, Lotus Symphony spreadsheets require VBA macros to be explicitly converted using an inbuilt engine.
These instructions relate to Lotus Symphony spreadsheets Beta released in September 2007.
To convert Microsoft Excel VBA macros to IBM Lotus Productivity Tools Basic:
The conversion is not ideal, however, as it assumes that only one subroutine resides in each module. This is commonly not the case in Excel VBA projects. Furthermore, the process cannot convert all VBA syntax and therefore depending on the complexity of the macro a lot of adaptation is required for the code to run smoothly in Lotus Symphony spreadsheets.
Other related posts are:
Migrating Excel VBA projects to OpenOffice Basic
Developing VBA code compatible with NeoOffice and Excel
|Excel Business Forums Administrator|
|Posted by Excel Helper on|
|There are currently no replies to the "Converting Excel VBA for Lotus Symphony Spreadsheets" topic of the Excel Help Forum for Developing and Auditing Analytical Models.|
|Find relevant Excel templates and add-ins for Converting Excel VBA for Lotus Symphony Spreadsheets in the Excel Business Solutions Directory|