Convert .CSV |-separated file to .xlsx file : <p>I have a .CSV file that is generated every day that opens in an Excel workbook. It is separated by | character like this: </p>

<pre><code>0-1-C|COUTEAU À HUITRE RICHARD|||||40|5,99|0|0|0|0|0|0|0|0|0|2,65|
 0000|ARTICLEVENTEFINALEdémonstrateur|||||945|9999,99|0|0|0|0|0|0|0|0|0|0|||||
00007|SUPER DÉTACHANT OOPS!|||SUPER DÉTACHANT||100|3,99|
</code></pre>

<p>Each line of the text above is in the first cell of a line .I'd like to generate a version of this file in another Excel workbook that uses one cell per string between |. The file is about 6200 lines long and since its generated everyday, I need it to juste loop over every line and create a new one in the document. I'm very new to VBA and and this website so p-lease be patient with me, thank you very much !</p>
