http://www.cpearson.com/excel/imptext.htm

Before you call the function, do

set rng = Cells(rows.count,2).End(xlup)(2)
rng.Select
ImportTextFile "c:\temp\test.txt", ","

Change the delimiter to match.

--
Regards,
Tom Ogilvy


"Michael Koerner" wrote in message
...
I would like to know how to insert a de-limited txt file at the next
available row in column B.

--

Regards
Michael Koerner