title: changing a URL for Excel Web Query
body: <p>I have an Excel 2010 spreadsheet that gets information from a data connection. On the properties of the connection is the "connection string" which is a URL with several parameters that are passed to the server in the query string. If you click "edit query" you can change the URL and then import new data based on the new URL. I need to do this via VBA.</p>
  
  <p>Let's say the connection string is currently <code>http://myserver.com?name=foo</code>
  I need to change that to <code>http://myserver.com?name=bar</code></p>
  
  <p>How can this be done?</p>