LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 224
Default Convert UTF-16 Unicode to UTF-8 Unicode?

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to convert Characters between Unicode and ANSI FcoMariscal Excel Programming 0 August 24th 06 10:47 PM
Convert a column to unicode James Ma Excel Discussion (Misc queries) 2 January 17th 06 01:21 AM
Can I use Excel to convert Chinese character into Unicode? Richard Hsiao Excel Discussion (Misc queries) 0 September 22nd 05 10:06 AM
getting unicode to convert from PC to MAC not a programmer Excel Discussion (Misc queries) 3 February 26th 05 01:27 AM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"