Wise Owl Answers - How do I use Google Translate with Excel VBA?

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This video shows you how to translate text from Excel using SeleniumBasic to work with Google Translate in Chrome. You'll learn how to set the text to be translated, how to extract the translated text, how to set the languages used and how to use a query string in the URL to avoid the need to locate multiple elements on the page.

Chapters
00:00 The Question
01:31 Accepting Cookies
02:45 Entering Text to be Translated
05:20 Extracting the Translated Text
08:35 Changing the Language Used
11:03 Setting the Text in the Query String
12:11 URL Encoded Strings

[datagru]

Thank you Andrew for keep enhancing your audience knowledge, that's really helpful. I highly appreciate.

[tejamarneni]

Good to hear from you Andrew after a long time.

[SalaOdyn]

I love your calm voice and precise on point information and hints ;) You are the best tutor there is.

[krn]

Thanks Andrew. Glad to see you are still around... :)

[danielteixeira]

I love your videos. My like is from Brazil 🇧🇷

[sergiorivaslamas]

You are a genious...Andrew. I will retake your VBA Playlist as soon as I could, thanks to those videos I could "update" some macros I typed years ago. Despite I wish to learn Python I guess I'stay with Excel. Greetings from Bolivia a place where Public servers still use Basic Microsoft Excel 2003 only in emergencies only in the case that their paper notebooks are filled....

[luisalfredosanchezm]

Oh man. You did something unbelievable 😎

[HuTrzy]

Thank you again for another great video !!! <3

[reevesjim]

Hi, Andrew!
I'm curious. Where du YOU learn all this, if not by watching your own amazing tutorials.

[TheSardOz]

Thank you Andrew, very interesting! Love to see an API videos with using Notion API if possible!!!

[AniManuSCh]

Amazing, is there a way to have the list of languages directly in excel like in a userform or something to select "from and to" translate before, like using power query to get the it but without physically putting the table on any sheet? and also letting the user choose bowser between chrome and explorer, etc to use google translate?

[richardadams]

Words can’t describe how helpful you have been, I just found your channel and I felt bad for myself..thank you..please sir do you have any tutorial on how to create SMS VBA ?

[SujoyDebnath]

Thank you sir for this amazing video..
Sir can you please provide a video on listobject. How to add a table in worksheet using vba and how to add, update, delete column, row in the table and how to add a table inside the table??

[apapa]

Very good! Can you help me write code that can read those words in excel by google sound. Thanks.

[ga-tvdgga-tvdg]

Could you help with setting up an automatic translation.

Now I do a few actions manually.

1. I run the VBA + Selenium program.
2. VBA. Selenium opens a web page.
3. Manually. On the worksheet, I right-click. A window opens with a list of commands.
4. Manually. I choose and click on line in the list "Translate to Lithuanian" (Versti į lietuvių).
5. VBA. Selenium. write the translated contents of a web page into a file
6. VBA. Selenium. Repeats points 2 to 6 n times.

Thank you for your help

[omgdataiseverything]

Hi
Please make a Vedio how to connect the Whatsaap Business API using VBA, I am Very Curious to know about that , I am regular follow your channel and waiting for it

[a.be.]

Thank you Andrew for this great video. I want to ask that if we have a word list existing in the range A1:A30, how we can create a cycle for translation? I need to change the cell manually now, how can we automatize translation?

[HADI-UPDATE]

Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy

[hedigson_]

Hola Andrew, haz sido un maestro en mi formación como programador vba. Tengo una pregunta. Es posible escribir código dentro del evento de una hoja desde un modulo? Saludos desde Venezuela.
Hi Andrew, you has been a master for me in my formation like a programmer vba. I've a question. It's possible write code inside a sheets event from a normal module??

[nenusaitham_Janasena_Kosam]

Thanks for your video. Can you help us to translate Chinese/Vietnamese languages into English using vba