canesbr
asked on
Excel VBA QueryTable Loop
In Excel VBA, how would I use QueryTables to loop through, for example, on http://translate.reference.com/ to supply a word, say English "two" and translate into every language on its drop down to>> list. Then store results in Sheet1 like
Afrikaans twee
Albanian dy
Arabic ¿¿¿¿¿
...
French deux
...
Yiddish ¿¿¿¿¿
Regards
Brian
Afrikaans twee
Albanian dy
Arabic ¿¿¿¿¿
...
French deux
...
Yiddish ¿¿¿¿¿
Regards
Brian
Brian
If you wanted to use QueryTables then the first thing you would probably need to do is find out if there is a URL that does the translation using the text entered and the language(s) picked.
For example this translates 'house' from English to Icelandic.
http://translate.reference.com/translate?query=house&src=en&dst=is&v=1.0
If you need to do this for multiple words and languages you would need to construct this URL using string concatenation.
Then you would need to use this URL for the QueryTable, which I assume is a web query.
You might have problems with that though, I'm afraid the URL doesn't return any data according to Excel.
If you wanted to use QueryTables then the first thing you would probably need to do is find out if there is a URL that does the translation using the text entered and the language(s) picked.
For example this translates 'house' from English to Icelandic.
http://translate.reference.com/translate?query=house&src=en&dst=is&v=1.0
If you need to do this for multiple words and languages you would need to construct this URL using string concatenation.
Then you would need to use this URL for the QueryTable, which I assume is a web query.
You might have problems with that though, I'm afraid the URL doesn't return any data according to Excel.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what do you mean by 'on its dropdown list'?
this is possible but need there clarifications.
is it possible to attach an example spreadsheet?