Problems with International Characters

[Guest_imported]

I’m converting an XML document to MS Excel, through VBA. Fine. Everything runs smooth except for one little glitch, and I’m at my wit’s end with it. I’m losing my international characters (like eacute, for example). Here’s how I’m bringing the text to cells:

MyRange.Value = iNode.selectSingleNode("text()&quot.Text

If, for example, the text value of the node would be “matériel”, all I would get is “mat”. The whole rest of the string gets truncated.

I’m going insane, please help

 

[flumpy]

Your document encoding is incorrect. You need to use a more useable standard.

change the encoding type of the XML document by using <?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?> at the start of your xml document.

If UTF-8 doesnt work , try other standards such as ISO.


Hope that helps,

Matt