OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Is anything possible in VBA also possible in OpenOffice?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
MrJK
Newbie
Newbie


Joined: 02 Jun 2006
Posts: 1

PostPosted: Fri Jun 02, 2006 1:29 pm    Post subject: Is anything possible in VBA also possible in OpenOffice? Reply with quote

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
View user's profile Send private message
rocket_scientist
General User
General User


Joined: 02 Jun 2006
Posts: 16
Location: Houston, TX

PostPosted: Fri Jun 02, 2006 1:57 pm    Post subject: Reply with quote

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. Wink
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger MSN Messenger
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Fri Jun 02, 2006 4:25 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group