Channel: WiseOwlTutorials

Category: Education

Tags: web scrapingscraping websiteschromefree tutorialseleniumbasiconline traininglanguagefree trainingmicrosofttranslateonline tutorialexcelgoogle chromevbaseleniumvisual basic for applicationsgoogle translatevisual basictutorialwise owl

Description: 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! 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 Visit wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!