title: Parse CSV, ignoring commas inside string literals in VBA?
body: <p>I have a VBA application that runs every day.  It checks a folder where CSVs are downloaded automatically, and adds their contents to a database.  When parsing them, I realized that certain values had commas as a part of their name.  These values were contained in string literals.  </p>
  
  <p>So I'm trying to figure out how to parse this CSV and ignore commas that are contained in string literals.  For example...</p>
  
  <pre><code>1,2,3,"This should,be one part",5,6,7 Should return 
  
  1
  2
  3
  "This should,be one part"
  5
  6
  7
  </code></pre>
  
  <p>I have been using VBA's split() function, because I don't wanna reinvent the wheel, but if I have to I guess I'll do something else.</p>
  
  <p>Any suggestions would be appreciated.</p>