From: Mac on
All-

Am afraid I already know the answer to this, but...: am interested in
compiling a set of java classes into .dll form to be later accessed
from MS' VBA. I realize this is likely making life much harder than
it needs to, but my deployment options are extremely limited, and
having an "externally" running application outside the IT-approved
norm (vs something "trusted"/"internal" like Excel) is currently a no-
go.

Is there any way to bridge the gap and allow this accessibility?

Appreciate any help/suggestions.

Mac
From: Jeff Higgins on
On 6/28/2010 8:52 PM, Mac wrote:
> All-
>
> Am afraid I already know the answer to this, but...: am interested in
> compiling a set of java classes into .dll form to be later accessed
> from MS' VBA. I realize this is likely making life much harder than
> it needs to, but my deployment options are extremely limited, and
> having an "externally" running application outside the IT-approved
> norm (vs something "trusted"/"internal" like Excel) is currently a no-
> go.
>
> Is there any way to bridge the gap and allow this accessibility?
>

Web service or some VBA/Java bridging package.
Either way you'll have to get it through IT administrators.

> Appreciate any help/suggestions.
>
> Mac

From: Arne Vajhøj on
On 28-06-2010 20:52, Mac wrote:
> Am afraid I already know the answer to this, but...: am interested in
> compiling a set of java classes into .dll form to be later accessed
> from MS' VBA. I realize this is likely making life much harder than
> it needs to, but my deployment options are extremely limited, and
> having an "externally" running application outside the IT-approved
> norm (vs something "trusted"/"internal" like Excel) is currently a no-
> go.
>
> Is there any way to bridge the gap and allow this accessibility?

10-12 years ago several product existed that could expose
a Java bean as a COM object.

If you can still find one of those then you can use it.

Arne

From: Arne Vajhøj on
On 28-06-2010 21:15, Arne Vajh�j wrote:
> On 28-06-2010 20:52, Mac wrote:
>> Am afraid I already know the answer to this, but...: am interested in
>> compiling a set of java classes into .dll form to be later accessed
>> from MS' VBA. I realize this is likely making life much harder than
>> it needs to, but my deployment options are extremely limited, and
>> having an "externally" running application outside the IT-approved
>> norm (vs something "trusted"/"internal" like Excel) is currently a no-
>> go.
>>
>> Is there any way to bridge the gap and allow this accessibility?
>
> 10-12 years ago several product existed that could expose
> a Java bean as a COM object.
>
> If you can still find one of those then you can use it.

http://www.rgagnon.com/javadetails/java-0045.html
http://www.nevaobject.com/j2cdetails.asp
etc.

Arne
From: rossum on
On Mon, 28 Jun 2010 17:52:53 -0700 (PDT), Mac <amackenzieus(a)yahoo.com>
wrote:

>All-
>
>Am afraid I already know the answer to this, but...: am interested in
>compiling a set of java classes into .dll form to be later accessed
>from MS' VBA. I realize this is likely making life much harder than
>it needs to, but my deployment options are extremely limited, and
>having an "externally" running application outside the IT-approved
>norm (vs something "trusted"/"internal" like Excel) is currently a no-
>go.
>
>Is there any way to bridge the gap and allow this accessibility?
>
>Appreciate any help/suggestions.
>
>Mac
How about J#? I know it is obsolete, but it is a way to get Java
source code into the Microsoft world.

rossum