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. |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com