title: XMLHTTP with Hash character
body: <p><br><br>
  I'm trying to scrape a website with xmlhttp and VBA.
  <br><br>
  The Url has a hash(#) symbol  and is misinterpreted by VBA...
  <br><br>
  This is the same problem as explained here :
  <a href="https://stackoverflow.com/questions/41530577/error-in-xmlhttp-get-request-with-special-character-in-url">Error in XMLHTTP Get request with Special character in URL</a>
  <br>
  The code is as follow : </p>
  
  <pre><code>Sub webscraping()
  Dim x               As String
  Dim req             As MSXML2.XMLHTTP60
  Dim doc             As HTMLDocument
  
  x = "https://search.gleif.org/#/search/"
  
  Set req = New MSXML2.XMLHTTP60
      With req
          .Open "GET", x, False
          .send
          If .Status &lt;&gt; 200 Then
              MsgBox "Http Request Error"
              Exit Sub
          End If
          Set doc = New MSHTML.HTMLDocument
          doc.body.innerHTML = .responseText
      End With
  End Sub
  </code></pre>
  
  <p>Thank you in advance</p>