Home > Forum Home > Developing and Auditing Analytical Models > Migrating Excel VBA projects to OpenOffice Basic | Share |
Forum Topic | Post Reply Login |
Migrating Excel Vba Projects To Openoffice Basic | Rate this: (1.6/5 from 11 votes) |
We are in the process to creating OpenOffice and StarOffice versions of our spreadsheet solutions. Business Spreadsheets has created an online Excel VBA to OpenOffice Basic Converter to facilitate this process for anyone attempting to undertake a similar migration. The Excel VBA to OpenOffice Basic converter also provides the ability for users to submit code conversion snippets in order to enhance the online conversion process as a community. This forum post can be used to share experiences, offer suggestions, and seek assistance for both using the converter and for migrating Excel VBA applications to OpenOffice equivalents in general. Other related posts are: Developing VBA code compatible with NeoOffice and Excel Converting Excel VBA for Lotus Symphony Spreadsheets | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
Replies - Displaying 1 to 5 of 5 | Order Replies By: Most Recent | Chronological | Highest Rated |
Rate this: (2.3/5 from 9 votes) The download contains both an Excel version and and OpenOffice version of the program with open source code. The spreadsheet program utilizes a dialogue input form for populating the bond data and an iterative function for calculating the yield to maturity. It therefore serves as a good example of how both user forms and sub routines can be converted from Excel VBA to OpenOffice Basic for OpenOffice or StarOffice Calc. | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Rate this: (2.3/5 from 10 votes) ----------- [http://www.softsea.com/] | |
Posted by auser on |
Rate this: (2.5/5 from 11 votes) I am unable make the Macro created in Excel to work with OpenOffice. I have tried the link http://www.business-spreadsheets.com/vba2oo.asp to convert the code but even that failed. Could you please help me with this. I just wanted to list all the files in a Folder (including Subfolders) in to the calc sheet. Please see the original VB code i was using in Excel. (attached) and please send me the code which will work in OO. VBA Code:
| ||
Joe | ||
Posted by Pavan on |
Rate this: (2.2/5 from 9 votes) I tried of all. Thanks! | |
Elemar Luiz Roters | |
Posted by elemar_roters on |
Rate this: (2.3/5 from 14 votes) Your approach to conversion appears to be clever. Thank you for this software. | |
Stephen Leibowitz | |
Posted by Stephen on |
Displaying page 1 of 1 |
Find relevant Excel templates and add-ins for Migrating Excel VBA projects to OpenOffice Basic in the Excel Business Solutions Directory |