Import of Multiple Text Files

  • Thread starter Thread starter yanks6rule
  • Start date Start date
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
 
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
 
Back
Top