| View previous topic :: View next topic |
| Author |
Message |
said General User

Joined: 09 Jun 2005 Posts: 11
|
Posted: Mon Mar 13, 2006 12:29 am Post subject: VBscript and OOO |
|
|
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 |
|
 |
pitonyak Administrator


Joined: 09 Mar 2004 Posts: 3618 Location: Columbus, Ohio, USA
|
Posted: Mon Mar 13, 2006 9:41 am Post subject: |
|
|
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 |
|
 |
said General User

Joined: 09 Jun 2005 Posts: 11
|
Posted: Wed Mar 22, 2006 2:23 am Post subject: |
|
|
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 |
|
 |
pitonyak Administrator


Joined: 09 Mar 2004 Posts: 3618 Location: Columbus, Ohio, USA
|
Posted: Wed Mar 22, 2006 6:19 am Post subject: |
|
|
| 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 |
|
 |
|