Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save worksheet with chinese characters as text
I use a data table in a worksheet in combination with VBA to generate
XML configuration files. Using VBA, I format the XML in a temp workbook and then save the temp workbook as XML using the following: ActiveWorkbook.SaveAs Filename:=thedir + thefile, FileFormat:=xlTextPrinter, CreateBackup:=False This has worked perfect for English, French, etc. However, it does not work for Chinese Mandarin or other character-based languages. When I save using FileFormat:=xlTextPrinter, I get ? for the characters. I've tried several other file formats. xlTextPrinter is the only file format that gives me a clean/correct XML file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chinese Characters ! | New Users to Excel | |||
Chinese characters - UTF8 CSV files | Excel Programming | |||
Exporting to CSV file with Chinese Characters in Spreadsheet | Excel Discussion (Misc queries) | |||
BUTTON CAPTION CHINESE CHARACTERS | Excel Programming | |||
Chinese characters | Excel Discussion (Misc queries) |