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


--
yanks6rule
------------------------------------------------------------------------
yanks6rule's Profile: http://www.excelforum.com/member.php...o&userid=30702
View this thread: http://www.excelforum.com/showthread...hreadid=503646

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


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=503646