Page 1 of 1

How to convert visual basic program to openoffice?

Posted: Thu Aug 14, 2008 2:35 pm
by thunderguy
Good day! moved to mac two days ago and would like to use open office. But i have one problem my visual basic programs don't work in open office. Is it possible to convert visual basic programs to use them in open office. I don't have time to write new ones for open office. Thank you

Re: How to convert visual basic program to openoffice?

Posted: Thu Aug 14, 2008 2:39 pm
by Hagar Delest
Hi and welcome!

See here: [Solved] OO 2.4 Calc Compatibility problem with MS Excel.

NB: don't use the green tickmark for your thread until it's fixed, else, users may not open it since it warns that the question has been answered (I've removed it).

Re: How to convert visual basic program to openoffice?

Posted: Thu Aug 14, 2008 2:42 pm
by thunderguy
sorry forgot to said that my visual basic programs were used in excel before and when i open excel file in calc nothing works.

Re: How to convert visual basic program to openoffice?

Posted: Thu Aug 14, 2008 5:31 pm
by Villeroy
It is not the language which makes the big difference. StarBasic is a subset of VBA. It's the thing you talk to by using the respective Basic dialect (or any other language in OOo). The author of an Excel macro or Excel add-in assumes the Excel application installed and running. All the keywords address objects of Excel documents, menu-items, Excel toolbars, ribbons, OLE objects and possibly a highly sophisticated operating system called Windows with registry entries, dll-calls, certain path-name conventions and stuff. Every VBA coder should have been aware that he utilizes a very, very specific technique that is totally incompatible to the entire sorftware world, which is perfectly intended by the creators of that technique.
Some flavours of OOo/StarOffice know a "compatibility mode" to map some of the most simple Excel-VBA to this program. But this is an expert feature. At best it runs without complaining. It's totally up to your expertise to judge if the running code does exactly the same thing in this application as it did in the other one. There are other examples where the code gets totally misinterpreted.

Re: How to convert visual basic program to openoffice?

Posted: Thu Aug 14, 2008 7:04 pm
by thunderguy
Unfortunately i'm not a programmer. So i wrote some simple program and now i want to use it in open office calc. so there is now converter, now i should write program again