Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Multiple Text Files into One Worksheet | Excel Programming | |||
Combine Text Files into One Worksheet | Excel Programming | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Multiple Text files into one worksheet-need help | Excel Discussion (Misc queries) | |||
open text files as a worksheet | Excel Programming |