Import of Multiple Text Files

Y

yanks6rule

I am looking to import about 75 data files for data analysis. I want to
load all of these files into the the same workbook using a macro. I am
new to the macro scence and have only begun to teach myself VB. Each
data file has two columns and they are tab delimited. I want to start
each text file at line 19 and they are named emi1.txt, emi2.txt and
then emi(2)1.txt emi(2)2.txt and so on for each experiment. Is there
any way I can write a macro to read all of these files in and label the
top of each column with the file name?

This would be such a great help.

Thanks
Bob
 
T

tony h

yes you can.

have a lok at the replies to Importing a .txt file issues . You
should be able to work it out from there but if not ask for more help.

regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Text files into one worksheet-need help 2
Import .txt files 1
Import data from multiple txt files into one xls file 3
Run-time error ‘13’ mismatch type 1
Excel 2007 Import .txt file error 1004 5
Multiple Files to Import 8
.txt import + saveas + mkdir 3
import multiple txt files in worksheet and formating 1

Top