title: VBA MSXML2.XMLHTTP60 with Yahoo finance
body: <p>I am pretty new with VBA, and the issue is that I am trying to scrape the web: <a href="https://finance.yahoo.com/screener/predefined/Aluminum" rel="nofollow noreferrer">https://finance.yahoo.com/screener/predefined/Aluminum</a> and get all sectors of each ticker of the list. The complex part (at least for me) is remove the filters "price" and "exchange" and send the request, I am using the following code, but I can´t not connect it propertly. Some suggestion? Many thanks</p>
  
  <pre><code>sub connect_to_web
  
  Dim XMLPage As New MSXML2.XMLHTTP60
  Dim url As String
  Dim query as string
  
  url="https://query1.finance.yahoo.com/v1/finance/screener?lang=en-US&amp;region=US&amp;formatted=true&amp;corsDomain=finance.yahoo.com"
  
  XMLPage.Open "Post", url, False
  XMLPage.setRequestHeader "Content-Type", "application/x-www-form-urlencoded; charset=UTF-8"
  
  XMLPage.send ""
  
  Debug.Print XMLPage.Status
  
  XMLPage.send ""
  
  Debug.Print XMLPage.Status
  
  end sub
  </code></pre>