Renske wrote:

If you release a new version, can I keep my current results somehow?

Yes. The next release will have code to import your old history.

I spent about 30 minutes on the level four test, saved my file, and closed excel to work on some other things.  When I tried to open the file the Test Kanji toolbar was not automatically opening.  I manually opened it, but when I tried to test it gave me this message:

The macro "Excel@Japanese.xls'!Testing.StartAffectingTest' cannot be found". 

I am also getting this message when I try to use any other functionality in the program.
I reinstalled the program and it gave me the same problem.  Has anyone else seen this?  It could be the computer I am using.  I will also try another computer as well.

Johnnyltn wrote:

You guys are fantastic. Sure, I can wait for the color change. Thank you for considering it . I appreciate that.

By the way, I get the following Microsoft Excel dialog box whenever I try to open up Help from your toolbar. Any ideas on why and what I might be able to do about it?
Here's the message I get:

"Unable to open http://www.chubunkyo.jp/japanese.php. Can not open the internet server or proxy server."

The original version of this program was Ocha No Kanji from (now defunct) choubunkyou. I just haven't updated the link or written a help file beyond the Welcome page.

darg_sama wrote:

jondesousa wrote:

I spent about 30 minutes on the level four test, saved my file, and closed excel to work on some other things.  When I tried to open the file the Test Kanji toolbar was not automatically opening.  I manually opened it, but when I tried to test it gave me this message:

The macro "Excel@Japanese.xls'!Testing.StartAffectingTest' cannot be found". 

I am also getting this message when I try to use any other functionality in the program.
I reinstalled the program and it gave me the same problem.  Has anyone else seen this?  It could be the computer I am using.  I will also try another computer as well.

I was actually running into a similar problem before... most likely if you use the CTRL+ shortcuts the program still functions properly, right? I fixed mine by opening Excel to an empty file, erasing the Excel@Japanese toolbar (view->toolbars->customize), then redownloading a fresh copy. It happened to me when I had an older version of the toolbar loaded which had problems.

You might want to wait for Mspertus to confirm that though as that's really his end of things ;P

Darg_sama,
This is a different problem. I think jondesousa has lost the macros (Excel sometimes loses the macros in a file if it becomes corrupt). He'll probably need to extract the file from the zipfile again

How complete is the list of vocabualry? looking at the 2級 section of this website:
http://www.asahi-net.or.jp/~ik2r-myr/kanji/kanji6pa.htm I see they have included the word 愛憎 (as an example of the difference between the two lists) as one of the compounds. Is this a mistake on their part for including it or has it been left out of the "excel@japanese" file?

I really want to get a fully complete file before I start taking it to pieces, if this could be clarified, i would be most appreciative.

Yorkii

thanks for the info.

so, i am now fairly confident that this list is complete.

Just downloaded this file and played around with it. Great tool to study kanjis and readings. I?m preparing for JLPT 2, so this is perfect for me... if it would only work properly. I?m using Office 2007 and I just can?t save the file. Excel always crashes when I save.

Anybody knows if Office 2003 has the same problem?

I seem to remember that the Anki developer was looking at a way to import your work from excel@japanese into Anki.  I don't know what if there was ever any progress on it though.

This is the accepted work around for the crashing problem (told to me by my friend who loves e@j).

1) Make sure you have macro security set to medium. (google it if you don't know how)
2) Open your e@j file and select disable macros.
3) Save your file
4) Close excel
5) Open you e@j file again and this time select enable macros
6) Run your tests
7) Save the file

If you follow these steps every time it is supposed to run fairly stable. I have tried these steps a couple of times and they seem to work.  My friend swears by this method.  Good luck to all those trying it.  I wonder what ever happened to Tango.

@dilandau23: Which version of Excel is your friend using? I'm using Excel 2003 and your workaround worked the first time I tried it (after the first run), didn't work afterwards. Just spent two hours trying all kind of settings, nothing really works.

What pity, this looks like a great tool.

watashimo wrote:

@dilandau23: Which version of Excel is your friend using? I'm using Excel 2003 and your workaround worked the first time I tried it (after the first run), didn't work afterwards. Just spent two hours trying all kind of settings, nothing really works.

I have 2003, you know I don't really use the program often, perhaps I could get my friend to post more about it.  As for making it work, I had the method I wrote above work only when it is followed exactly, ie no extra "save" steps and the first save must be with macros off. Also if you save in the wrong order or incorrectly, I could envision the file itself becoming corrupt.  In that case you would perhaps have to start over.  This is unquestionably a program that requires you to make frequent backup copies of the file.  You may do better trying one of the premade Anki decks if what you like about e@j is just the fact that the input step has already been done.  E@j really is fragile.  I know even my friend said he would switch to Anki if he didn't have some much work already done in e@j.

EDIT:

Just put the Office 2003 CD into my drive to install Excel 2003.
I have some questions with regards to you method: So after the first run I save my file without disabling the macros. Then I open this file again, disable the macros and save it. I close Excel another time and open the file again, this time with macros enabled. Sounds a little complicated, but if it works with Excel 2003, I'll be happy.

No its like this and must be exact:
1) open file with macros off
2) save file
3) close excel
4) open file with macros on
5) do you "tests" (as many as you want apparently)
6) save file
7) close excel

Last edited by dilandau23 (2007 September 12, 6:59 pm)

Nice tool.

I love Excel and macros!