Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to write other language in text file from VBA
i have one excel sheet , in that sheet, user input in chineese character. i want to create a text file in chineese based on the user input
Please help me in this regard Thanx in advanc Ravi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to write other language in text file from VBA
Writing Chinese characters to a text file is the same as writing English and numbers
For example, you got a list of Chinese words in column A. The following macro writes the content in Column A to the text file "TESTFILE.txt". See the following macro Sub write_file( Dim tmp As Singl Open "TESTFILE.txt" For Output As #1 ' Open file for output For tmp = 1 To Range("A1").CurrentRegion.Rows.Coun Write #1, Range("a1").Offset(tmp - 1, 0).Value ' Write comma-delimited dat Nex Close #1 ' Close file End Su I speak Chinese and use both Simplified and Traditional Chinese in Windows English version. I tested the above approach and had no problem at all with the above macro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can someone write this formula for me in Excel 2003 Language | Excel Worksheet Functions | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
write 1-dimensional array of integers to text file | Excel Programming | |||
opening and write to a text file in excel | Excel Programming | |||
write a line from Excel to a text file | Excel Programming |