I 've done this type stuff before. It may be a little tricky because
the byte order of the 16 bit data may be reversed. I don't understand
how UTF-16=UTF-7. UTF-16 is two byte data without any parity. UTF-7 is
7 bit data which may or may no contain a parity bit. UTF-8 is 8 bit
data with no parity so you can get 256 characters.

I don't understand what tab delimited UTF-16 means. I would need to
see a sample of the data. Tab delimited I've only seen as 7 or 8 bit
data. whatt happens to the data if you open it in NOTEPAD? Notepad
will automatically convert UTF-16 to UTF-8 (it may look a little
funny).

Usually the UTF-16 problems aresolved opening the data file as binary
in VBA and then writing some code to change the format. I usually open
two files from VBA (one input binary and one output no binary) if I
don't need the final results in a spreadsheet. Otherwise, I open just
one file as binary input and read the data into excel worksheet.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=192392

http://www.thecodecage.com/forumz