The process will stop with message “not able to load special characters”. ![]() When you try to load a ANSI encoded xml file with special characters into Excel, it will give error. When you download a xml data from any server that contains unicode characters, it is possible that the data is saved in ANSI format, if it is manually saved. Where this UTF8 conversion can be useful? This enables the system to store data in enhanced unicode format to hold the extra characters. ObjFS.SaveToFile sOutFilePath, 2 '2: Create Or Update Sub convertTxttoUTF(sInFilePath As String, sOutFilePath As String) Here is the code to change the encoding of a ANSI file. To store non English or special characters in a text file, the encoding has to be changed from text to UTF. The unicode format is used in files that has non English characters in the data. VBA code to convert Text to UTF8 (.Txt to Unicode) ![]() This will convert the opened file format from plain text to a unicode format. In dropdown near Save button, select UTF8. ![]()
0 Comments
Leave a Reply. |