Placin Data In Next Avaialble Cell
 

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

--

Regards
Michael Koerner

Placin Data In Next Avaialble Cell
 

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

Placin Data In Next Avaialble Cell
 

Thanks Tom, will check it out over the holidays. Merry Christmas and a Happy
and Prosperous New Year.

--

Regards
Michael Koerner


"Tom Ogilvy" wrote in message
...
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