I manually removed all references to j.dll from the registry.
Excel was no longer able to access j.dll services.
I ran regsvr32 j.dll in a cmd window. It reported success, but there were no
registry updates actually made.
I ran regsvr32 j.dll in a cmd windows as administrator. It reported success
and
the registry was updated.
I ran regsvr32 for both J701_32 and J702_64 j.dll.
I enabled "Jsoftware : JDLLServer Type Library" in References - VBAProject from
the Excel 2010_32 macro editor.
Excel 2010_32 was now able to access j.dll and run the macro.
All of the Excel testing is 32 bit, since I no longer have access to 64 bit
Excel.
Based on my previous tests with Excel 2010_64 Beta, I suspect Excel 2010_64
will
work with a registered version of j.dll from j64_701.
I also tried using j.dll 701 from J602 32 and 64 via callj.ijs:
NB. =========================================================
foo=: 3 : 0
jinit''
r=.''
r=.r,(<jcmd '9!:14'''''),(<jcmd'>(4 8 i.3!:0 <.2^33){''Got J64'';''Got J32''')
jfree''
r
)
Running on J602_32:
foo''
┌──────────────────────────┬───────┐
│j701/beta/2010-03-31/11:40│Got J32│
└──────────────────────────┴───────┘
Running on J602_64:
foo''
┌──────────────────────────┬───────┐
│j701/beta/2009-12-06/14:40│Got J64│
└──────────────────────────┴───────┘
--
On 12/25/2010 11:41, Eric Iverson wrote:
> Did you find you had to a manual registry update.?I think regsvr32 j.dll
> would do the required. If you tried that and it didn't work I would like to
> know. Thanks for pursing this.
>
> On Sat, Dec 25, 2010 at 10:11 AM, David Mitchell<[email protected]>wrote:
>
>> I manually updated the registry on Win7_64 and tried Excel 2010_32 and J701
>> beta
>> with a macro that used j.dll.
>>
>> It seems to work fine.
>>
>> I noted the results of this test here:
>>
>> http://www.jsoftware.com/jwiki/Scripts/JfromExcel
>> --
>>
>> On 12/16/2010 16:17, Eric Iverson wrote:
>>> COM J64 is not officially supported. It might just work, but as far as I
>>> know no one has given it a shot. Note that in J7 there is no JEXEServer
>> and
>>> there is only a JDLLServer. Not that I can put any time into it now, but
>> I'd
>>> be interested in a report on experiments.
>>>
>>> On Thu, Dec 16, 2010 at 3:45 PM, Steven Taylor<[email protected]>
>> wrote:
>>>
>>>> Hi,
>>>>
>>>> I know this is probably legacy technology as far as you guys are
>>>> concerned... I was wondering if there were any plans to update the COM
>>>> interface currently available in j602 j.dll?
>>>>
>>>> I know it's there in j7. I'm running the 64 bit j602 client, but I can't
>>>> talk to it over 64 bit COM. I haven't done any serious tests with it
>> yet
>>>> though... perhaps it's there already.
>>>>
>>>> Yes COM is long-in-the-tooth, but it's quite convenient for some things.
>>>>
>>>> btw: thanks for the hard work.
>>>>
>>>> cheers,
>>>> -Steven
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
