title: Google Places Details to Excel with VBA
body: <p>I'm trying to get a full detail list of Google places to an Excel sheet by using a Text Search request to Google.</p>
  
  <p>So I want to perform an API query (?) by </p>
  
  <ol>
  <li><p>writing a search string to an Excel cell</p></li>
  <li><p>getting the VBA to query Google "<a href="https://developers.google.com/places/web-service/search#PlaceSearchRequests" rel="nofollow noreferrer">Place Search</a>" and returning a temporary list of Placeid's matching the search string</p></li>
  <li><p>getting the VBA to query all the details of the previous step's Placeid's with Google "<a href="https://developers.google.com/places/web-service/details#PlaceDetailsRequests" rel="nofollow noreferrer">Place Details</a>" and writing them to the sheet</p></li>
  </ol>
  
  <p>So the code should "chain" these two APIs to my understanding. I have an API key already for Google.</p>