From ooo-dev-return-17619-apmail-incubator-ooo-dev-archive=incubator.apache.org@incubator.apache.org Thu May 3 05:18:28 2012 Return-Path: X-Original-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EA1D6CDB8 for ; Thu, 3 May 2012 05:18:27 +0000 (UTC) Received: (qmail 98038 invoked by uid 500); 3 May 2012 05:18:27 -0000 Delivered-To: apmail-incubator-ooo-dev-archive@incubator.apache.org Received: (qmail 97967 invoked by uid 500); 3 May 2012 05:18:26 -0000 Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-dev@incubator.apache.org Delivered-To: mailing list ooo-dev@incubator.apache.org Received: (qmail 97949 invoked by uid 99); 3 May 2012 05:18:26 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 May 2012 05:18:26 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of dave2wave@comcast.net designates 76.96.30.24 as permitted sender) Received: from [76.96.30.24] (HELO qmta02.emeryville.ca.mail.comcast.net) (76.96.30.24) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 May 2012 05:18:17 +0000 Received: from omta08.emeryville.ca.mail.comcast.net ([76.96.30.12]) by qmta02.emeryville.ca.mail.comcast.net with comcast id 5HFd1j0050FhH24A2HHw8P; Thu, 03 May 2012 05:17:56 +0000 Received: from [192.168.1.74] ([67.180.51.144]) by omta08.emeryville.ca.mail.comcast.net with comcast id 5HHv1j00V36gVt78UHHvi9; Thu, 03 May 2012 05:17:56 +0000 Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Apple Message framework v1084) Subject: Re: A wiki about how to support a VBA API From: Dave Fisher In-Reply-To: <4FA20D6F.9030107@pitonyak.org> Date: Wed, 2 May 2012 22:17:55 -0700 Content-Transfer-Encoding: quoted-printable Message-Id: <056414AC-242B-43C8-9AD3-17FEAD6F4DE7@comcast.net> References: <4FA20D6F.9030107@pitonyak.org> To: ooo-dev@incubator.apache.org X-Mailer: Apple Mail (2.1084) On May 2, 2012, at 9:45 PM, Andrew Douglas Pitonyak wrote: > On 05/02/2012 04:29 AM, Peng Chen wrote: >> Hi All, >> I post a wiki about how to support a VBA API in OpenOffice, >> = http://wiki.services.openoffice.org/wiki/How_to_support_a_VBA_API_in_OpenO= ffice >>=20 >> Any feedback will be appreciated, thanks. >>=20 > I am almost embarrassed to say this, but after having read it, I have = no idea what the article is about. I think that the problem is that I = lack the proper vocabulary. For example, when I see "VBA", I think = "Visual Basic Applications", which is something that MSO (Microsoft = Office) supports, and not OOo (OpenOffice.org). >=20 > Is this an article related to the VBA compatibility mode stuff that = can be enabled using a specific Option from inside of StarBasic? >=20 > After I have a handle on exactly what is accomplished, then I will = read this again, since it looks like you are probably answering some = very specific questions that I have in areas that I do not fully = understand, but have searched for in the past. >=20 > Sorry for my lack of immediate understanding. I'm not sure what I am reading either. My reference is using Apache POI = and its User Defined Function (UDF) capability to rewrite a VBA function = in Java. This allows me to have a different implementation of a VBA = function that is not in a Basic derivative. Whether that works or not = depends on whether I can accurately code the VBA in Java. This is not = easy. I think that this API may be more about "UDF" support than VBA support. To me VBA support means that I can run my MS Office VBAs in the program = without any trouble. Still, UDF support is useful. VBA support is a panacea. What's it all about Peng? Regards, Dave >=20 > --=20 > Andrew Pitonyak > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt > Info: http://www.pitonyak.org/oo.php >=20