新聞財經娛樂♬資訊 News Economy

I get one textfile file and its  format with character seperator of "|" and I am using following VBA code to get
the data and parsing into Excel sheet
workbooks.OpenText filename:="http://www.example.com/getData",DataType:=xlDemlimited, _
Others:=True, OtherChar:="|"

and it works fine but the parsing data output will be put into column direction instead of row direction.
Since it is more 1000 seperator of "|", so I prefer to parse the data into row direction

Orginal Textfile file and its format as follows:
123|AB|123|ABCD......................................

output from the previouse OpenText function in Excel 2003 VBA code,
123    AB    123   ABCD

My expectation for parsing textfile data by OpenText VBA code
123
AB
123
ABCD

Since the file is in text format and NOT csv format, so I think I need to
change setting to let the OpenText function to do parsing data into row data
but How, I google it in website, no information about the issue,

Please advise
Duncan

Yes.  It looks like your data only contains one column and that "|" was used as the record/row delimiter, rather than vbCrLf.

You can pre-process the file and use the .OpenText method.  

Alternatively you can read the entire contents into a string variable (one operation) and then use Split() function to parse the data on the "|" character.

If you copy that parsed data into a two dimensioned array, you will be able to move it into your worksheet in one operation.  I describe this in my Fast Data Push to Excel article:
http://www.experts-exchange.com/A_2253.html

change all the | to vbCrLf and then import the data into your worksheet.

The above is from Excel 2003 help.