| View previous topic :: View next topic |
| Author |
Message |
MrJK Newbie

Joined: 02 Jun 2006 Posts: 1
|
Posted: Fri Jun 02, 2006 1:29 pm Post subject: Is anything possible in VBA also possible in OpenOffice? |
|
|
Hi,
I have recently downloaded OpenOffice with a view to creating an OpenOffice version of a MS Word Add-In. However, before I start looking at conversion too in-depth, I was just wondering how OpenOffice Basic compares to Word's VBA in terms of the range of commands available.
For example, one thing the macro must do is loop through a document, find relevant text and return the page number the text is on. With Word that is simply 'Selection.Information(wdActiveEndAdjustedPageNumber)'
Would this sort of thing be possible in OpenOffice? Or is it a case of I'm probably going to run into lots of things that can be easily done in VBA but are hard/impossible to do in OpenOffice?
Thanks
PS Having done a Google search on another OO command that I would need (.uno:InsertBreak) I see there are only 14 results. My concern is that there isn't going to be enough documentation available to enable me to convert the VBA code to OpenOffice. With VBA you can usually Google a command and find a decent amount of helpful results. My programming capabilities are strictly amateur! |
|
| Back to top |
|
 |
rocket_scientist General User


Joined: 02 Jun 2006 Posts: 16 Location: Houston, TX
|
Posted: Fri Jun 02, 2006 1:57 pm Post subject: |
|
|
That is a huge question, and I'm the last person who would know. Nevertheless... work asked me to do it so I'm doing it. (converting VBA to OO Basic). I can tell you that OO Basic is a fully functional, yet entirely different language from VBA. In certain cases, I have found functionalities in OO Basic that did not exist or I didn't know how to do them in MS Office. Basically, if you can do it in VBA, chances are you can do it in OO, just depends on how persistent you are. Since they're paying me to do it... i'm pretty persistent.  |
|
| Back to top |
|
 |
JohnV Administrator

Joined: 07 Mar 2003 Posts: 8995 Location: Lexinton, Kentucky, USA
|
Posted: Fri Jun 02, 2006 4:25 pm Post subject: |
|
|
| Your example is certainly doable in OOo but it would require more code than that. On the other hand there is a lot a of help here for the asking. |
|
| Back to top |
|
 |
|