The only way I know of doing this is to open the text file ( as alread
done) then copy column a to column p



To copy from Column A to column P same sheet

Activesheet.columns("A").Copy Destination:=Activesheet.columns("A")

To Copy to a different worksheet

Activesheet.columns("A").Copy Destination:=Workbooks("Nam
Here").sheets("Sheet Name".columns("P"

--
Message posted from http://www.ExcelForum.com