How to convert visual basic program to openoffice?
-
- Posts: 5
- Joined: Thu Aug 14, 2008 1:21 pm
How to convert visual basic program to openoffice?
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
- Hagar Delest
- Moderator
- Posts: 32628
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: How to convert visual basic program to openoffice?
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).
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).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
-
- Posts: 5
- Joined: Thu Aug 14, 2008 1:21 pm
Re: How to convert visual basic program to openoffice?
sorry forgot to said that my visual basic programs were used in excel before and when i open excel file in calc nothing works.
OOo 3.0.X on Mac OSx Leopard
Re: How to convert visual basic program to openoffice?
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.
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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 5
- Joined: Thu Aug 14, 2008 1:21 pm
Re: How to convert visual basic program to openoffice?
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
OOo 3.0.X on Mac OSx Leopard