title: Find distance between two cities in Excel using Google Maps API
body: <p>I would like a table of the following form:</p>
  
  <pre><code>Point A         Point B           Mileage
  Los Angeles     Miami             292100
  Palo Alto       San Francisco     90
  </code></pre>
  
  <p>I was hoping to use Google Maps or some other geo api to generate mileage based on input cities dynamically. Any ideas on how to do this?</p>
  
  <p><strong>UPDATE</strong> It looks like I could use the <code>getDistance()</code> function in <code>GDirections</code>. I could write JavaScript without too much difficulty to do this, but how would I incorporate that into Excel?</p>
  
  <p>I could put the JS in an html file that takes a query string and returns the distance of the route. Then, I could set Excel up to use that connection. Or is that an excessive amount of work? And hasn't something like this been done before?</p>