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/diction...ji=<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.

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?

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?