title: Safe way to web scrape within VBA
body: <p>I need to scrape some price data from a website. To get this done, I use the following snippet:</p>
  <pre><code>With http
      .Open &quot;GET&quot;, url, False
      .send
      html.body.innerHTML = .responseText
  End With
  Set topics = html.getElementsByClassName(&quot;sidebar-item-label&quot;)
  
      For i = 1 To topics.Length - 1
      str = topics(i).href
  </code></pre>
  <p>It works, but I am wondering how to secure the data, before assigning the <code>html response</code> to my variable <code>str</code>. To avoid malicious code get run on my windows machine, I need to validate, sanatize and escape the response data, before safe it to the variable and do the further stuff like string splitting and save it into my Excel spreadsheet.</p>
  <p>Does anybody can help me with that? Do you need more informations?</p>