title: Save a HTTP request response as CSV in VBA
body: <p>I'm using the MSXML2.XMLHTTP method to connect to an API via VBA. My preferred response format is in a CSV, but I'm unsure of how to take the <code>API.responsetext</code> value and save it as a CSV locally.</p>
  
  <p>Even pasting to a new or existing sheet in the active workbook would be useful.   </p>
  
  <pre><code>Option Explicit
  Sub getData()
  
  Dim API As Object
  
      Set API = CreateObject("MSXML2.XMLHTTP")
  
      API.Open "GET", "https://factsetfundamentals.xignite.com/xFactSetFundamentals.csv/GetFinancialStatements?IdentifierType=Symbol&amp;Identifiers=CSCO&amp;StatementTypes=BalanceSheet,CashFlowStatement&amp;AsOfDate=1/22/2019&amp;ReportType=Annual&amp;ExcludeRestated=False&amp;_token=7C6B46D98F6B4B0C88FF5A5CE2C64C0C", False
      API.Send
  
  End Sub
  </code></pre>