Groups > comp.lang.java.programmer > #24014

Re: Using JAVA inside VBA

X-Received	by 10.66.13.3 with SMTP id d3mr4370957pac.40.1368366907542; Sun, 12 May 2013 06:55:07 -0700 (PDT)
X-Received	by 10.49.81.66 with SMTP id y2mr143957qex.23.1368366907130; Sun, 12 May 2013 06:55:07 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!ka17no6050245pbb.1!news-out.google.com!ln4ni1892pbb.0!nntp.google.com!kk15no7362772pbb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.lang.java.programmer
Date	Sun, 12 May 2013 06:55:06 -0700 (PDT)
In-Reply-To	<XLGdnRwvt7kexhLMnZ2dnUVZ7oidnZ2d@bt.com>
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> <XLGdnRwvt7kexhLMnZ2dnUVZ7oidnZ2d@bt.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<18974868-a160-4ac1-a2e2-dbfcf494eb3d@googlegroups.com> (permalink)
Subject	Re: Using JAVA inside VBA
From	Ghislain <gbenrais@gmail.com>
Injection-Date	Sun, 12 May 2013 13:55:07 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.lang.java.programmer:24014

Show key headers only | View raw

Le dimanche 12 mai 2013 11:02:02 UTC+2, Chris Uppal a écrit :
> Ghislain wrote:
> 
> > Hello,
> 
> > I have a compiled commercial jar that I want to use in VBA, something
> 
> 
> 
> > 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).
> 
> >
> 
> > Do you have any ideas ?
> 
> 
> 
> Buy the commercial product ?
> 
> 
> 
> Wrap the JAR up in an executable that makes the API available over TCP/IP, and 
> 
> then create a COM object that uses that network interface ?
> 
> 
> 
> If you are capable of developing simple COM objects in C++, then it might be 
> 
> simpler to use something like Jace:
> 
>     http://code.google.com/p/jace/wiki/Overview
> 
> to create JNI-based wrapper code that your COM-server layer can talk to.
> 
> 
> 
> Open Office / Libre Office used to be able to talk to Java, as I understand it. 
> 
> Maybe they still can, and it would be easier for you to use your existing 
> 
> commercial component with one of them.
> 
> 
> 
> If you have the remarkably good sense, not to mention good fortune, to be a 
> 
> Smalltalk programmer, then you could use Dolphin Smalltalk (which can generate 
> 
> COM objects) + my very own (advt.) JNIPort to bridge between COM and Java...
> 
> 
> 
> But buying the commercial product seems the best bet to me.  After all, you've 
> 
> already paid for the two products you want to connect, why baulk at paying for 
> 
> the bridge too ?
> 
> 
> 
>     -- chris

Thank you Chris for these interestings ideas. 
I already bought the awfully expensive software but it is only available in java.
I'll try jace but I understand it is not as simple as it used to be with the sun's packager.
Ghislain

Thread

Using JAVA inside VBA Ghislain <gbenrais@gmail.com> - 2013-05-11 09:31 -0700
  Re: Using JAVA inside VBA Arne Vajhøj <arne@vajhoej.dk> - 2013-05-11 12:41 -0400
    Re: Using JAVA inside VBA Ghislain <gbenrais@gmail.com> - 2013-05-11 11:45 -0700
      Re: Using JAVA inside VBA Real Gagnon <usenet@videotron.ca> - 2013-05-12 22:52 +0000
      Re: Using JAVA inside VBA Arne Vajhøj <arne@vajhoej.dk> - 2013-05-12 20:28 -0400
        Re: Using JAVA inside VBA Ghislain <gbenrais@gmail.com> - 2013-05-13 01:43 -0700
  Re: Using JAVA inside VBA "Chris Uppal" <chris.uppal@metagnostic.REMOVE-THIS.org> - 2013-05-12 10:02 +0100
    Re: Using JAVA inside VBA Ghislain <gbenrais@gmail.com> - 2013-05-12 06:55 -0700
    Re: Using JAVA inside VBA Arne Vajhøj <arne@vajhoej.dk> - 2013-05-12 20:31 -0400

csiph-web