Import multiple text files to 1 cell and a new row in Excel using VBA?
<p>I am trying to import multiple text files to cells A1, A2, A3 etc.
This means text file 1 would go to A1
text file 2 should go to A2
text file 3 should go to A3</p>

<p>On stackoverflow i found a <a href="https://stackoverflow.com/questions/30476545/import-multiple-text-files-to-a-new-row-in-excel-using-vba">code</a> that looks almost like what i am trying to do except for the creation of new columns.</p>

<p>The problem is that the text strings in the files are delimited and put in new columns, as this is the purpose of the code (using the alternative given in the answer).</p>

<p>I don't know what to change in this code to put all the text of file 1 in cell A1. 
I hope it's possible, if not i appreciate any thoughts about other solutions.</p>