Search the Community

I need to develop an app that talks to a non-unicode application. This application (graphic) can set font encoding on different objects, so my task is bascially Read string in Excel 2003 or 2007. This string will be UniCodeConvert each character in the string to ANSI (Win12xx)Either save the converted string to a text file or send the string by Ethernet socketTo give an example of point 2: Take the string [Москва] In Unicode this would be 041C 043E 0441 043A 0432 0430 (PROBABLY encoded as 1C 04 3E 04 etc since Excel uses Little Endian) This can be converted to Win1251 according to http://en.wikipedia.org/wiki/Windows-1251 End result would be CC EE F1 EA E2 E0 My question is: has someone done a / know of a UDF to do this job (feed a string of LE bytes in, get a string of ANSI bytes out) - or is there a native Windows function ? If someone could post a small example going from $instring = Москва I would be really happy for any help Attached is a ZIP with two text files. Unicode BOM is the source format. Win1251 destination format. moskva.zip