hi...i want to write a macro to get data from two text files one after the other.It is basically to create a report. To start with, first i hav to prepare colum heading for the data from text file1. Then i hav to import data from the same text file(text file1). After this i have to leave three lines , and i have to prepare the column heading for the data from text file2. Then I have to import the data from the same text file(text file2). The problem i am facing here is am not able to prepare the heading for the data from text file2,becoz the size of text file1 vary each time . Bcoz of this problem am not able to specify a perticular line where i should write the column headings. Can anyone help me on thi s pls????