Hello everyone,

This is my first time coming here, and my first experience with merging macro codes within excel. I seem to be stuck and was hoping someone could help me out.

Here is the situation: I have several ".txt" files with data that was pulled from a machining test. I need to pull the files into one excel document with each a worksheet for each ".txt" file. Each worksheet needs to named with the ".txt" file name. I did find code to do this, but the data will not pull into excel file the delimited formatting. Basically one cell has three data points in it instead of three columns of data that include the headers. Hopefully I'm explaining this correctly.

Can anyone help?

Thank you!