Hi all, I have an issue regarding encoding in a XML file. I'm using scandinavian letters like "æ, ø, å"... and these are doing the damage. I loop a selection based on several rows testing if the text are bold etc. This is the start of my VBA code: Open "C:\test.xml" For Output As #1 Print #1, " " then it loops through several cells and adds text etc. There are no error when I check the XML file in Notepad++, but when I do the same in e.g. XML Notepad or Firefox i get an error. The error message translated from Danish to English are: "Interpreting XML error: not well-formed" and it highlights the "æ" <-- danish letter. I have tried changing the encoding from UTF-8 to UTF-16 and ISO-8859-1 but it doesn't help... What to do? /Anders

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

XML encoding from VBA

Thread starter exAHSacto
Start date Dec 8, 2011
Tags

encoding vba xml

exAHSacto

New Member

Dec 8, 2011

Hi all,

I have an issue regarding encoding in a XML file. I'm using scandinavian letters like "æ, ø, å"... and these are doing the damage.

I loop a selection based on several rows testing if the text are bold etc.

This is the start of my VBA code:

Code:

    Open "C:\test.xml" For Output As #1
    Print #1, "<xml version=""1.0"" encoding=""UTF-8"">"
then it loops through several cells and adds <strong>text</strong> etc.

There are no error when I check the XML file in Notepad++, but when I do the same in e.g. XML Notepad or Firefox i get an error. The error message translated from Danish to English are: "Interpreting XML error: not well-formed" and it highlights the "æ" <-- danish letter.

I have tried changing the encoding from UTF-8 to UTF-16 and ISO-8859-1 but it doesn't help...

What to do?

/Anders