IMPORTING TEXT FILES TO EXCEL - Multiple Multi-line text files, each in a new column

Hello all,

I have multiple multi-line text files that I am trying to import into one sheet. I would like each text file to have its own column.

Thus far, I have successfully pulled them all in to one column using the code that user patel45 posted here:

Please Login or Register  to view this content.

Would anyone be able to help me figure out what to add to this code to make each text file have its own column?

Thank you in advance! (And thank you to patel45 for at least getting me started in the right direction.)

1. Move drow =2 to the line after Do While and replace the original drow to dcol = 1
2. Just before the loop add in dcol = dcol + 1
3. Replace the ,1 in the Cells() statement to dcol

Man, I gotta get quicker at this VBA stuff. I start to work on something and someone beats me to it! Not that I was anywhere near finishing, but, looking at pj...'s code, I was on the right path