X-Received: by 10.224.215.194 with SMTP id hf2mr14931306qab.0.1368297924661; Sat, 11 May 2013 11:45:24 -0700 (PDT)
X-Received: by 10.49.106.231 with SMTP id gx7mr1728846qeb.6.1368297924647; Sat, 11 May 2013 11:45:24 -0700 (PDT)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!l3no4758970qak.0!news-out.google.com!y6ni29564qax.0!nntp.google.com!m7no4824690qam.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.lang.java.programmer
Date: Sat, 11 May 2013 11:45:24 -0700 (PDT)
In-Reply-To: <518e74ad$0$32105$14726298@news.sunsite.dk>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=212.198.209.211; posting-account=H_Z2rQoAAADkazawAYqrjzkd2DMgMj1H
NNTP-Posting-Host: 212.198.209.211
References: <825e44b1-bf36-4dfc-9d90-df4beffb7f7b@googlegroups.com> <518e74ad$0$32105$14726298@news.sunsite.dk>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <76b69dc2-d1cc-4095-b4a1-e44a1eabda96@googlegroups.com>
Subject: Re: Using JAVA inside VBA
From: Ghislain <gbenrais@gmail.com>
Injection-Date: Sat, 11 May 2013 18:45:24 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Xref: csiph.com comp.lang.java.programmer:24010

Le samedi 11 mai 2013 18:41:16 UTC+2, Arne Vajh=F8j a =E9crit=A0:
> On 5/11/2013 12:31 PM, Ghislain wrote:
>=20
> > I have a compiled commercial jar that I want to use in VBA, something l=
ike :
>=20
> > Dim javaob As Object
>=20
> > Set javaob =3D CreateObject("MyJavaAPIObject")
>=20
> > result =3D javaob.doSomething()
>=20
> >
>=20
> > Unforunately, I can't convert the API to a COM object. As far as I know=
, it was possible 10 years ago but it is no longer possible unless you use =
commercial products (like EZJCom).
>=20
> >
>=20
> > Do you have any ideas ?
>=20
>=20
>=20
> 12-15 years ago wrapping Java beans as COM objects was hot.
>=20
>=20
>=20
> Not any more.
>=20
>=20
>=20
> But try and see if something like:
>=20
>=20
>=20
> http://www.rgagnon.com/javadetails/java-0045.html
>=20
>=20
>=20
> still works.
>=20
>=20
>=20
> Arne

Thanks Arne but I had tried it already and the packager used is not working=
 anymore. I think the article was written by the time it worked (a long tim=
e ago)
Ghislain