From: Mac on 28 Jun 2010 20:52 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 28 Jun 2010 21:07 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 28 Jun 2010 21:15 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 28 Jun 2010 21:18 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 29 Jun 2010 08:59
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 |