Google Translate Excel VBA run time 424 issue - getElementByID

[dhng]

I used the below Excel VBA function for Google Translate, and it worked perfectly in October 2018. But this week, I tried to use it, and I get the run time error 424 (object required) at the following line:

CLEAN_DATA = Split(Application.WorksheetFunction.Substitute(IE.Document.getElementById("result_box").innerHTML, "</SPAN>", ""), "<")

Do you know what has changed in the past month to result in this code not working anymore? I think the ID for Google Translate may have changed, but I do not know how to check and pull the correct ID for the translation results.

-------------

Please Login or Register  to view this content.

[FDibbins]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[dhng]

I chatted with a friend who is familiar with HTML. He was able to check out the Google Translate website and find the new name for the translation box. Here is the code that works now.

CLEAN_DATA = Split(Application.WorksheetFunction.Substitute(IE.Document.getElementsByClassName("tlid-translation translation")(0).innerHTML, "</SPAN>", ""), "<")


So, this will work till Google changes it ...

[FDibbins]

Thanks for the feedback, Im sure it will help members