title: Google translate cell value using VBA
body: <p>I'm trying to convert other languages to English using auto detect by triggering the below code.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>Sub transalte_using_vba()
  
  Dim ie As Object, i As Long
  Dim inputstring As String, outputstring As String, text_to_convert As String, result_data As String, CLEAN_DATA
  
  Set ie = CreateObject("InternetExplorer.application")
          
          inputstring = "auto"
      
          outputstring = "en"
          
          text_to_convert = Sheet3.Range("A2")
  
   'open website
  
      ie.Visible = False
      ie.navigate "http://translate.google.com/#" &amp; inputstring &amp; "/" &amp; outputstring &amp; "/" &amp; text_to_convert
     
      Do Until ie.ReadyState = 4
          DoEvents
      Loop
    
      Application.Wait (Now + TimeValue("0:00:5"))
      
      Do Until ie.ReadyState = 4
          DoEvents
      Loop
  
      CLEAN_DATA = Split(Application.WorksheetFunction.Substitute(ie.Document.getElementById("result_box").innerHTML, "&lt;/SPAN&gt;", ""), "&lt;")
  
      For i = LBound(CLEAN_DATA) To UBound(CLEAN_DATA)
          result_data = result_data &amp; Right(CLEAN_DATA(i), Len(CLEAN_DATA(i)) - InStr(CLEAN_DATA(i), "&gt;"))
      Next
      Sheet3.Range("B2") = result_data
      ie.Quit
      MsgBox "Done", vbOKOnly
      
  End Sub</code></pre>
  </div>
  </div>
  </p>
  <p>However i'm facing <strong>Runtime error 424 object required</strong> in line <code>CLEAN_DATA = Split(Application.WorksheetFunction.Substitute(ie.Document.getElementById(&quot;result_box&quot;).innerHTML, &quot;&lt;/SPAN&gt;&quot;, &quot;&quot;), &quot;&lt;&quot;)</code></p>
  <p>What is wrong with the code?</p>
  <p>This code is working bit slow.. as I need to work on bulk data more than 70K is there any quick way to do this?</p>
  <p>In my system I have google chrome as default browser and can we use it for translation, which may help to run the script faster?</p>