How to convert visual basic program to openoffice?

Creating a macro - Writing a Script - Using the API

How to convert visual basic program to openoffice?

Postby thunderguy » Thu Aug 14, 2008 2:35 pm

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

Re: How to convert visual basic program to openoffice?

Postby Hagar Delest » Thu Aug 14, 2008 2:39 pm

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).
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to convert visual basic program to openoffice?

Postby thunderguy » Thu Aug 14, 2008 2:42 pm

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

Re: How to convert visual basic program to openoffice?

Postby Villeroy » Thu Aug 14, 2008 5:31 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27094
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to convert visual basic program to openoffice?

Postby thunderguy » Thu Aug 14, 2008 7:04 pm

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


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 6 guests