Leigh, Here is an example I posted in February of how I used J7 j.dll from Excel.
http://jsoftware.com/pipermail/programming/2011-February/021961.html -- Cheers, David Mitchell On 5/11/2011 15:25, Leigh J. Halliwell wrote: > Thanks for the answer, Raul. Things with j701 must be altogether different. > To quote from your reply, "The concept of registering J as a COM server is > ... not supported in J701." > > Excel macros of mine have given instructions to j602. To do this I've > needed in VBA to define and create js as CreateObject("jexeserver"). Then > Excel can issue commands to J in statements like js.Do. But before creating > the object, one must use the VBA menu Tools/References. It's all described > in the section "COM, OLE, and OCX" of the User Manual. The first step is to > run jreg.bat, as described in the Manual section "J OLE Automation Server." > Is all this out-of-date with j701? What must I do so that Excel will "see" > j701 out there, and appropriate its properties and methods? > > If you can't detail this to me, can you point me to the j701 literature? > Thanks again. > > Leigh > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Raul Miller > Sent: Wednesday, May 11, 2011 2:48 PM > To: Programming forum > Subject: Re: [Jprogramming] Register j701 > > On Wed, May 11, 2011 at 2:28 PM, Leigh J. Halliwell > <[email protected]> wrote: >> Is j701 ready for serving an Excel client? The User Manual (Packages/Com) >> is geared to j501. > > Personally, I do not know what this question means. > > That said: > >> Finding no jreg.bat file, I copied the 602 jreg.bat to j701/bin and ran > it. >> But the J DLL and EXE Servers in my VBA References still point to the 602 >> versions of j.dll and j.exe. Thanks for an explanation. > > jreg.bat (and the concept of registering J as a COM server) is > supported in J602 (at least the 32 bit version) but is not supported > in J701. > > Raul > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
