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

**psmith33** · 04-21-2015, 09:29 AM

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

**JBeaucaire** · 04-21-2015, 10:37 AM

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

Edit both macros above as needed for your system.

**psmith33** · 04-21-2015, 10:52 AM

Thanks for the quick reply, Jerry. However, I have another preformatted template text file that has text before and around the area where I would like the data to be imported. Can you give me an idea of how to write out the data in that spot?

DEFINE CABLE NETWORK
INCLUDE ELEMENTS <<CABLE_NETWORK_ELEM.txt>>
ATTACH JOINTS <<CABLE_NETWORK_ATTACH.txt>>

UNITS INCHES KIPS DEG
<<POLE PROPERTIES FORM.txt>> OR <<STEEL POLE PROPERTIES LOADS.txt>>

**JBeaucaire** · 05-04-2015, 02:49 PM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] HELP: Copy Data from Multiple CSV files to an output xls file

Creating multiple Excel Files using one template from another master file of data

Insert additonal rows into multiple files in a folder based on Master Template(Old file)

Creating Multiple Output Files from a Master File and updating data between workbooks

Consolidate Data from Multiple Files (Different File Names) into a Master File

Bookmarks

Bookmarks

Posting Permissions