I just discovered the microsoft translator in excel to translate things from one language to another. I have a need of translating "addresses" in english to some other language and i would like to do this via vba. But when i use the "macro-recorder" with the translator.............i get nothing which would indicate how ot use the translator via vba.
Addresses don’t need translating ...what exactly do you want to translate? Is it the country?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
the addresses i was referring to was like street addresses or home addresses..........basically translate a street or home or business address.
OK - sorry to ask, but to what end? An address is like someone's name - it doesn't change, regardless of the language you are using.
i have addresses in english that i need to convert to Ukraine. Thats it. There is a translate tool inside excel that when i do it manually works good enough......but i cant figure out how to automate it using excel
Ah! You mean that you want them converting phonetically into Cyrillic script? That's NOT translation, it's transliteration.
Last edited by AliGW; 07-09-2020 at 09:24 AM. Reason: Typo corrected.
there is a "translate" button under the review menu that does what i want.....but for some reason i cant access it via vba or at least i dont know how
anyone have any ideas?
If that does what you want, then use:
Please Login or Register to view this content.
Rory
thanks i will try it but to be honest i am not sure how to "try" this one line of code.......how do i specify the txt to translate and where is the "from" and "to" language specification.
You don't - that is just the exact equivalent of clicking the Translate button. I don't know if the actual Translate functionality is programmable.
There are couple of different iteration of this feature. Non of them exposes control to vba. Since, it's pretty much Web API call and not processed locally.
If you need to automate translation process, you'll need to write code to leverage Google Translate, MS Translator (Azure Cognitive Service) via Web API request.
Alternately, you can pilot IE and scrape information from translation sites.
Ex:
https://stackoverflow.com/questions/...text-using-vba
Last edited by CK76; 07-09-2020 at 09:58 AM. Reason: Grammar
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks