An important point you might have missed in the advice given so far is that regsvr32 must be run as admin to work. Run as a normal task it unfortunately lies and reports success when nothing as been done.
On Mon, Feb 21, 2011 at 1:11 PM, Graham Parkhouse < [email protected]> wrote: > I didn't use cmd.exe the first time: I have now, but I still get the same > error message when I run your macro, and it stops on the same line. I've > only done it with J701 and everything is 32 bit. > > I have been looking up a lot of stuff on the internet, but am not greatly > encouraged. It seems you have to register every macro, and then only if its > written in C++, C#, F# or Jscript, and NOT the J script I'm looking for! I > was hoping I could attach a script file to a directory containing my Excel > file and get ready access to the functions in J. OK, I expect to reference > each function, with name in Excel, name in J, argument types etc - no > problems. But this seems beyond my reach at the moment. > > Gratefully > > Graham > > David Mitchell wrote: > > > > Graham, > > > > You are welcome. > > > > The Excel help search shows several possible explanations for error > > 429. > > > > I suspect that the most likely cause is that you may not have the > > correct > > version of J7 J.DLL registered for the version of Excel you are > > running. > > > > All of the versions I currently have of Excel are 32 bit versions. I > > did use a > > beta version of 64 bit Excel for a while, but it expired. > > > > So, I make sure that I have registered the current 32 bit version of > > J.DLL when > > I use Excel. > > > > I believe you can register both the 32 and 64 bit version of J.DLL and > > Win7 will > > figure out which to use, but it has been a while since I tried that. > > > > So, the safest way is to make sure that the last version of J.DLL you > > register > > matches your version of Excel. > > > ------------------------------ > > > > Message: 2 > > Date: Mon, 21 Feb 2011 10:45:30 -0500 > > From: David Mitchell <[email protected]> > > Subject: Re: [Jprogramming] J embedded in Excel > > To: Programming forum <[email protected]> > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > > > One more thought. I always use a cmd window with Administrator > > authority to run > > regsvr32. > > > > On Win7, you can type > > > > cmd.exe > > > > in the search window of the command window. When you see cmd.exe show > > up at the > > top of the search window, right-click it and select "Run as > > administrator". > > > > After answering Yes to the UAC prompt, you can then cd to the J bin > > directory > > and run regsvr32. > > > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
