+- kanji koohii FORUM (http://forum.koohii.com)
+-- Forum: Learning Japanese (http://forum.koohii.com/forum-4.html)
+--- Forum: Learning resources (http://forum.koohii.com/forum-9.html)
+--- Thread: Help with my Excel/VB study tool (/thread-6138.html)
Help with my Excel/VB study tool - cjane - 2010-08-06
As I'm studying RTK kanji, I'm putting together an Excel speadsheet with kanji, readings, example vocabulary etc. that I'm also learning. I've also written some VB to give me a front-end, and allow me to query my spreadsheet and display results. I'm trying to incorporate audio files for the vocabulary, and I've managed to include the audio files I have from Anki decks I've been using. I've put the mp3 file name in a cell and I can play it using my front-end form.
My question is, I'd like to include a query to the assets.languagepod101.com website for any audio that I do not have, and then save the audio mp3 file to my computer for future use. In effect, I want to do what the AudioDownload Plugin does in Anki, but from my spreadsheet, ie I've got the kana and kanji in spreadsheet cells, I want to pass these to assets.languagepod101.com, get back an mp3 and save it. I know the syntax (http://assets.languagepod101.com/dictionary/japanese/audiomp3.php?kana=<kana>kanji=<kanji>) but don't know how to do the query and get the resulting file in VB. Any-one out there how to do this?
Many thanks
CJ
Please ignore this, I've found out how to do it using URLDownloadToFile.
Help with my Excel/VB study tool - bladethecoder - 2010-08-07
Quote:I've also written some VB to give me a front-end, and allow me to query my spreadsheet and display results. I'm trying to incorporate audio files for the vocabulary, and I've managed to include the audio files I have from Anki decks I've been using. I've put the mp3 file name in a cell and I can play it using my front-end form.That sounds like a useful tool. Would you be willing to share it?
Help with my Excel/VB study tool - Tobberoth - 2010-08-07
What's the actual point of your tool? Seems like all you're doing is copying your anki work into a spreadsheet and displaying it, why not simply use Anki?