How to convert visual basic program to openoffice?

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
thunderguy
Posts: 5
Joined: Thu Aug 14, 2008 1:21 pm

How to convert visual basic program to openoffice?

Post 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
User avatar
Hagar Delest
Moderator
Posts: 32628
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to convert visual basic program to openoffice?

Post 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).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
thunderguy
Posts: 5
Joined: Thu Aug 14, 2008 1:21 pm

Re: How to convert visual basic program to openoffice?

Post 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.
OOo 3.0.X on Mac OSx Leopard
User avatar
Villeroy
Volunteer
Posts: 31270
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to convert visual basic program to openoffice?

Post 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.
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
thunderguy
Posts: 5
Joined: Thu Aug 14, 2008 1:21 pm

Re: How to convert visual basic program to openoffice?

Post 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
OOo 3.0.X on Mac OSx Leopard
Post Reply