title: what is the problem with my http GET?
body: <p>in VBA i am creating a URL:</p>
  
  <pre><code>URL = "http://api.local.yahoo.com/MapsService/V1/geocode?appid=" &amp; yahoo &amp; "&amp;street=" &amp; street &amp; "&amp;city=" &amp; city &amp; "&amp;state=" &amp; state &amp; "&amp;zip=" &amp; zip
  </code></pre>
  
  <p>for example it sets itself to equal this:</p>
  
  <pre><code>http://api.local.yahoo.com/MapsService/V1/geocode?appid=username123&amp;street=1893 n. clyde morris blvd &amp;city=daytona beach&amp;state=FL&amp;zip=32117
  </code></pre>
  
  <p>when i manually go to this URL, IT WORKS FINE. </p>
  
  <p>however when i do this:</p>
  
  <pre><code>'Create Http object
  If IsEmpty(http) Then Set http = CreateObject("WinHttp.WinHttpRequest.5.1")
  
  'Send request To URL
  http.Open "GET", URL
  
  http.send
  'Get response data As a string
  
  response = http.responseText
  </code></pre>
  
  <p>it's giving me this for the response:</p>
  
  <pre><code>response="Watch :   : response : "&lt;!doctype html public "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"&gt;
  &lt;html&gt;&lt;head&gt;&lt;title&gt;Yahoo! - 400 Bad Request&lt;/title&gt;&lt;style&gt;
  /* nn4 hide */ 
  /*/*/
  bod........"
  </code></pre>
  
  <p>please note that 50% of the time it returns the correct URL and 50% it gives me a <code>400 bad request</code></p>
  
  <p>what am i doing wrong?</p>
  
  <p>wrikken has suggested that i get a URLencoder, but i believe that it was encoding it correctly! </p>