How can I export txt(UTF-8 characterset) from Excel?

[HOONHEE]

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...

 

[Halim]

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

 

[HOONHEE]

Thank for your reply..

Hmmm...

Chiness use my excel program with their computer in China.

When they clik "Create File" button, VBA process do converting.
Chiness upload the result text file to Web System.

When I query DB. All Chiness cracked.
Oracel DB NLS = UTF-8

Can my VBA coding convert excel to text with "UTF-8" characterset?

 

[Halim]

Hi,

try to use this:

ActiveWorkbook.SaveAs Filename:= _
"C:\china.txt", FileFormat:=xlUnicodeText , CreateBackup:=False

xlUnicodeText --> is most important