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

VBscript and OOO

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


Joined: 09 Jun 2005
Posts: 11

PostPosted: Mon Mar 13, 2006 12:29 am    Post subject: VBscript and OOO Reply with quote

Hi,
This is a call for providing vbscript compatbility for OOO2.
As you can see, Novell will provide this in his next version of Distribution
http://www.novell.com/products/desktop/preview.html

But I think it will be a closed module not avalaible for all version of OOO.
So, is there anyone who can developp this functionnality?

Thanks
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Mon Mar 13, 2006 9:41 am    Post subject: Reply with quote

At least one version of StarOffice also offers this capability, but this is not an open source solution so it is not distributed with OpenOffice.org.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
said
General User
General User


Joined: 09 Jun 2005
Posts: 11

PostPosted: Wed Mar 22, 2006 2:23 am    Post subject: Reply with quote

Hi;
I've just installed ooo novell edition.
It's work with my excel file.
I had an excel file with a simple macro which copy and paste cells made with VB.
The only error I have is that my excel is in french so OOO do not know a formula like :
=SI(T2="","-","a livrer")
I think I have to change the syntax to ooo format :
=IF(T2='';'-';'a livrer')
I will try to work on it.
But I also think that I can't connect to a database as I do with VB.
For example, I've got an access table, I put the paramters in excel then a macro will connect to the database, do the query and then fill a sheet with the result

I'm sad that it's not an open source solution. Is there any open source solution for that?
Most companies here are ready to change for ooo but the big problem is that their developpers had created macros in vb for retrieving data from access, or various data source and now they don't want to recode everything (they don't want to learn again a new language and how to redo their job)

I don't know about the licensing but if we can give that feature to people, there will be a mass of migration.

PS . Sorry for my english. I better speak in french
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Wed Mar 22, 2006 6:19 am    Post subject: Reply with quote

Quote:
I'm sad that it's not an open source solution. Is there any open source solution for that?

No. There is no open source solution that allows VB macros to run in OOo.
You can use database from OOo. I have never used an Access database, but I believe that this is possible.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
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