View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Halim Halim is offline
external usenet poster
 
Posts: 5
Default How can I export txt(UTF-8 characterset) from Excel?

hi,
may be the problem occure while your windows doesnt support with asian
language / Chineese
Try to setup language option from control panel
--
Regards,

Halim



"HOONHEE" wrote:

Hi!
First. I'm sorry. I'm not used to English. ^^;
i'm using VBA in Excel(Office 2003).
I used "SaveAs" Method for coversion Excel to Text File with VBA...( For
uploading Oracle DB with Other Program)
But.
When Execel convert to Text File, Chiness words cracked during converting.
One man said me.
"When You convert excel to Text file.. change characterset 'UTF-8'!!"

I find SaveAs Option "xlUnicodeText" FileFormat.
I can't find Option about "UTF-8" fileformat.

How can I convert Excel to txt file with UTF-8 encoding...

If You know that. Advise me ^^;

Thanks you...

--
Everyday is a little life!!
Thank u!!