I want to use the code below with something added that says {If End of
sheet, create new sheet, continue import on new sheet.}

Workbooks.OpenText Filename:="ftp://ftp.unknown.com/CSV_feed.txt",
_
Origin:=437, StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlNone _
, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False,
Comma:= _
False, Space:=False, Other:=True, OtherChar:="|",
FieldInfo:=Array( _
Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5,
1), Array(6, 1), Array(7, 9), _
Array(8, 1), Array(9, 2), Array(10, 9), Array(11, 9), Array(12,
9), Array(13, 9), Array(14, _
1), Array(15, 1), Array(16, 9), Array(17, 1), Array(18, 9),
Array(19, 9), Array(20, 9), _
Array(21, 1)), TrailingMinusNumbers:=True


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=567084