为了让OpenOffice.org Calc读取Excel文件中的VBA代码，我需要做些什么？ [英] What do I need to do in order to get OpenOffice.org Calc to read the VBA code in an Excel file?

问题描述

我的雇主正在考虑安装OpenOffice.org的Office产品套件，而不是使用Microsoft Office。我在Access和Excel中编写了几个高级应用程序，我试图找出什么是OpenOffice.org将不会兼容的。

具体来说，我需要做些什么才能让Calc（OpenOffice.org的Excel版本）在宏的宏和事件中读取并执行VBA，并将宏事件按钮点击？ p>

另外请注意，我正在使用Excel中的MySQL连接器来动态更新电子表格中的数据。我需要做些什么来保护我们的MySQL服务器的数据连接？

谢谢

解决方案

据我所知，OOo Base可以连接到一个mdb文件，以便它可以打开表和查询。我认为其他任何东西 - 表单，重新输入，宏和VBA都需要重新开发。

我不相信OOo Calc可以读取或执行VBA有自己的Basic的方言，它有一个变体的语法。据我所知，它不支持Class的概念。有些工作似乎正在发生，但是有关详细信息，请参阅 OpenOffice Wiki 。现在，我会说你应该计划一个仔细和完整的重写。

关于MySQL连接器 - 我会说这是你的最小的担忧..

在正面上，您可以在一年或两年内获得真正的工作安全性，同时您将所有东西移植！

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.

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?

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?

Thanks

解决方案

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.

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.

Regarding the MySQL connector - I'd say that's the least of your worries...

On the plus side, you're likely to have real job security for a year or two while you get everything ported!

这篇关于为了让OpenOffice.org Calc读取Excel文件中的VBA代码，我需要做些什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！