Home > Forum Home > Developing and Auditing Analytical Models > Converting Excel VBA for Lotus Symphony Spreadsheets Share

Converting Excel VBA for Lotus Symphony Spreadsheets

Excel Help for Converting Excel Vba For Lotus Symphony Spreadsheets in Developing and Auditing Analytical Models


Forum TopicPost Reply Login

Converting Excel Vba For Lotus Symphony Spreadsheets

Rate this:
(3/5 from 1 vote)
ShockedIn 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:
  • Open the Excel spreadsheet in Lotus Symphony spreadsheets.
  • Select Tools > Macros > Macro.
  • Navigate to the module that needs to be converted and select Edit.
  • The Basic editor will open displaying the original Excel VBA Code.
  • There is a small square black button at the very right of the toolbar to convert the VBA code to IBM Lotus Productivity Tools Basic.
  • After the process has been run statistics are displayed detailing how many lines of VBA code were and were not converted.
  • The lines were not converted are simply commented out.

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 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.

Post Reply

Find relevant Excel templates and add-ins for Converting Excel VBA for Lotus Symphony Spreadsheets in the