title: Retrieving data from a site through a secured proxy
body: <p>My client will access my company's site to retrieve data information, using a sub I am working on. This has to be done using a secured proxy, since his company blocks access to some sites. I can't test my sub on his computer and obviously he cannot send the proxy information (ie.:Username, passoword, ip, port...)</p>
  
  <pre><code>Sub login_sub()
  
      url = "http://localhost/php004/loginExcelAddin.php?username=" + username + "&amp;password=" + password
      Dim httpObject As Object
      Dim response As String
      Set httpObject = CreateObject("WinHttp.WinHttpRequest.5.1")
      httpObject.Open "GET", url, False
      httpObject.SetProxy HTTPREQUEST_PROXYSETTING_PROXY, proxyIP + ":" + proxyPortNumber
      httpObject.send
      response = httpObject.responseText
      On Error GoTo errorHandler
      If response = True Then
          loggedIn = True
          MsgBox "You are logged in"
      End If
      Application.Calculate
      Exit Sub
  
  errorHandler:
      MsgBox "Login has failed"
  
  End Sub
  </code></pre>
  
  <p>(Username, password, proxyPortNumber, proxyIP are public variables filled in a form)</p>
  
  <p>I am struggled with this issue for a while. Anyone could tell me if I am going to the right direction, can I send this code for the client?</p>
  
  <p>Thanks</p>