Hello, new at VBA macros and have three .txt files (POLE.txt, CABLES.txt, CONNECTORS.txt) that contain data. I would like to run a macro to pull the data from these files into a specific spot in the prefilled template file (marked by their names) and the output would be called STRUCTURE_OUTPUT.txt.

Here is how the output file would look before running the macro, it would then pull the data into the appropriate spot.

STRUCTURE OUTPUT FILE

UNITS INCHES LBS DEG
COORDINATES

<<POLE.txt>>
<<CABLES.txt>>


TYPE SPACE FRAME
MEMBER INCIDENCES


<<CONNECTORS.txt>>

Can anyone give me any guidance or help on this would be greatly appreciated.

Pete