This is NOT a VB question per se... it is more of an Excel csv parsing question... I didn't know which would be the best forum to pose the question and I am using VB so that is why I chose this forum...

Hypothetical situation...

Making a CSV file...
Line one has three columns with this content

Code:
first          A,B"C       third

If I make the string
first,A,B"C,third

It is interpreted as
first         A              B"C        Third

If I make the string
first,"A,B"C",third

It is interpreted as
first        A,BC"         third
How do I get it to ignore the imbedded commas and quotes in the second field?????