Combine Text Files into One Worksheet
 

This group is better than any "formal" training a gal could have. I've
learned a lot over the years from you and I have another question that I know
you can help with. I need to combine multiple text files into one worksheet.
This should be fairly straight forward, however I just can't get my arms
around it. The text files (6 to 8 of them) need to have fixed length
columns, with all columns formatted as text to retain leading zeros. The
number of rows will most likely end up around 7000 for each text file.

The code I have works fine, with a large portion of the various subs coming
from this group. However, I don't think it needs to be as complex as it is.

I have a Sub ImportTextFile which brings in the multiple text files and
starts 3 other subs designed to combine the text files into one worksheet.
Would you please share with me what you would do to accomplish this task?