title: Web scraping DEEPL.com using VBA Excel and Selenium
body: <p>i'm trying to code a function to translate sentences in Excel using DEEPL.com
  My approach is using Selenium to scrape the web using Chrome (as IExplore is not supported by the web).</p>
  <pre><code>Public Function deepL(txt As String, inputLang As String, outputLang As String)
  Dim url As String
  Dim driver As New WebDriver
  
  url = &quot;https://www.deepl.com/translator#&quot; &amp; inputLang &amp; &quot;/&quot; &amp; outputLang &amp; &quot;/&quot; &amp; txt
  driver.Start &quot;Chrome&quot;
  driver.Timeouts.ImplicitWait = 5000
  driver.Get url
  
  deepL = driver.FindElementById(&quot;target-dummydiv&quot;).Text
  driver.Close
  
  End Function
  ----
  Sub translating()
  'test for word &quot;probando&quot; from &quot;es&quot; to &quot;en&quot;
  'url: https://www.deepl.com/translator#es/en/probando
  'it should return: &quot;testing&quot;
  MsgBox (deepL(&quot;probando&quot;, &quot;es&quot;, &quot;en&quot;))
  End Sub
  </code></pre>
  <p>The problem comes when loading the web, so the div containing the translation is empty on load, and the GET instruction returns an empty text.
  But after 1 second, the page refreshes with the correct result:</p>
  <pre><code>&lt;div id=&quot;target-dummydiv&quot; aria-hidden=&quot;true&quot; class=&quot;lmt__textarea lmt__textarea_dummydiv&quot; lang=&quot;en-US&quot;&gt;testing&lt;/div&gt;
  </code></pre>
  <p>I tried adding an implicit wait of 5 seconds in order to give time to the webpage to load, but the result is the same.</p>
  <p>What am I doing wrong?</p>
  <p>EDIT: I found that the div with the translation has visibility: hidden. If I show the visibility, the results are correct, but don't know how to get that in my code</p>