Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Using JAVA inside VBA

Show all headers | 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

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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