VBA code to insert data from multiple .txt files into one output file template file

This could be an extremely simple thing to do if you:

1) Create text files that include the portions of the test that doesn't change in your sample above. The first text file would have this, including that blank line at the end:

STRUCTURE OUTPUT FILE

UNITS INCHES LBS DEG
COORDINATES

The second one you would create would have this, including the two blank rows at the top and botton:

TYPE SPACE FRAME 
MEMBER INCIDENCES

2) Change your filenames to something that puts the files in the correct order when viewed in the folder.

1Title.txt
2POLE.txt
3CABLES.txt
4Title.txt
5CONNECTORS.txt


3) Now this very simply macro which calls Window's own ability to merge text files in a folder:

Shell(Environ$("COMSPEC") & " /c  COPY C:\SourceFolder\*.txt C:\OutPutFolder\All.txt")

You could even create a .BAT file stored in the same folder with just this one line of code, doubleclick the file anytime you want to run it.

COPY C:\DataDump\*.TXT C:\DataDump\ALL.TXT

Edit both macros above as needed for your system.

Pretty sure my suggestion in post #2 for splitting that preformatted text file out is the solution.