My employer is considering installing OpenOffice.org's suite of Office products instead of using Microsoft Office. I've written several advanced applications in Access and Excel, and I'm trying to figure out what will and will not be compatable with OpenOffice.org.
我的雇主正在考虑安装OpenOffice.org的Office产品套件，而不是使用Microsoft Office。我在Access和Excel中编写了几个高级应用程序，我正在试图弄清楚OpenOffice.org会与之兼容的内容。
Specifically, what do I need to do to have Calc (OpenOffice.org's version of Excel) read and execute VBA in macro's and tie macro events to button clicks?
具体来说，我需要做什么让Calc（OpenOffice.org的Excel版本）在宏中读取和执行VBA并将宏事件与按钮点击联系起来？
Also of note, I'm using the MySQL Connector from within Excel to dynamically update data in the spreadsheet. What might I need to do to preserve data connectivity to our MySQL server?
另外值得注意的是，我在Excel中使用MySQL Connector来动态更新电子表格中的数据。我需要做些什么才能保持与MySQL服务器的数据连接？
Thanks
谢谢
2 个解决方案
#1
5
As far as I know, OOo Base can connect to an mdb file to the extent that it can open tables and queries. I think anything else - forms, reqportes, macros VBA and native - would need to be redeveloped.
据我所知，OOo Base可以连接到mdb文件，以便它可以打开表和查询。我认为还需要重新开发其他任何东西 - 表单，reqport，宏VBA和native。
I don't believe that OOo Calc can read or execute VBA: it has its own dialect of Basic, which has a variant syntax. It doesn't, as far as I can tell, support the concept of Class, for example. Some work appears to be occurring, however, see the OpenOffice Wiki for more information. Right now, I'd say you should be planning on a careful and complete rewrite.
我不相信OOo Calc可以读取或执行VBA：它有自己的Basic方言，它有一个变体语法。据我所知，它并不支持Class的概念。有些工作似乎正在发生，但是，请参阅OpenOffice Wiki以获取更多信息。现在，我会说你应该计划仔细而完整地重写。
Regarding the MySQL connector - I'd say that's the least of your worries...
关于MySQL连接器 - 我会说这是你最不担心的......
On the plus side, you're likely to have real job security for a year or two while you get everything ported!
从好的方面来说，当你把所有东西搬进去的时候，你可能会有一到两年真正的工作保障！
#2
#1
5
As far as I know, OOo Base can connect to an mdb file to the extent that it can open tables and queries. I think anything else - forms, reqportes, macros VBA and native - would need to be redeveloped.
据我所知，OOo Base可以连接到mdb文件，以便它可以打开表和查询。我认为还需要重新开发其他任何东西 - 表单，reqport，宏VBA和native。
I don't believe that OOo Calc can read or execute VBA: it has its own dialect of Basic, which has a variant syntax. It doesn't, as far as I can tell, support the concept of Class, for example. Some work appears to be occurring, however, see the OpenOffice Wiki for more information. Right now, I'd say you should be planning on a careful and complete rewrite.
我不相信OOo Calc可以读取或执行VBA：它有自己的Basic方言，它有一个变体语法。据我所知，它并不支持Class的概念。有些工作似乎正在发生，但是，请参阅OpenOffice Wiki以获取更多信息。现在，我会说你应该计划仔细而完整地重写。
Regarding the MySQL connector - I'd say that's the least of your worries...
关于MySQL连接器 - 我会说这是你最不担心的......
On the plus side, you're likely to have real job security for a year or two while you get everything ported!
从好的方面来说，当你把所有东西搬进去的时候，你可能会有一到两年真正的工作保障！