Convert UTF-16 Unicode to UTF-8 Unicode?

G

Greg Lovern

If I save an Excel file as "Unicode Text" (xlUnicodeText), I get a tab-
delimited UTF-16 (also known as UTF-7) unicode file.

How can I convert it to UTF-8?


I've been doing the conversion by automating Word from Excel:

Const WORD_TEXT_FORMAT As Long = 2 'FileFormat:=wdFormatText
Const WORD_UTF8_ENCODING As Long = 65001 'Encoding:=65001

ObjWordDoc.SaveAs _
Filename:="save as UTF-8.txt", _
FileFormat:=WORD_TEXT_FORMAT, _
Encoding:=WORD_UTF8_ENCODING


However, now I need to convert from UTF-16 to UTF-8 on computers that
may not have Word installed. Any suggestions?


Thanks,

Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert UTF-16 Excel file to UTF-8 and back 1
How can I export txt(UTF-8 characterset) from Excel? 4
about encoding UTF-8 and UTF-16 6
UTF-8 File Opened in Excel from Firefox Browser 1
Text File Encode to UTF-8_Unicode specific 1
Fail to open unicode txt file in excel 8
Excel VBA to save .xls file as UTF-8 text file 1
Unicode UTF-08 3

Top