Convert text to HTML for use in XML

[exAHSacto]

Hi all,

I really hope you can help me on this one.

I need to convert plain text to HTML language, so I can use it in a XML file. In other words I need to insert a lot of "< /b</B>", etc.

I have the text in Word atm, but I can move it to Excel, if that should help.

If I save the document as a web page, then the HTML code contains a lot of noice. Here is an example:

<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span lang=DA
style='mso-ansi-language:DA'>Det her skal virke<o:p></o:p></span></b></p>

I have tried using online converters, but that is not a viable solution.

best regards
Anders

 

[exAHSacto]

Okay.

Do you know the correct encoding when I create a XML file in VBA?

this is what I got:

Print #1, "<xml version=""1.0"" encoding=""UTF-8"">"

/Anders

 

[Norie]

You are missing the ? after < and before >.

 

[exAHSacto]

okay. But it won't let me write danish letters like "æ,ø,å"... do you know why?

 

[Norie]

I thought the data was in a text file?

Do you mean that when you read the data from the file and then write it to the destination file these characters are lost or changed?

 

[exAHSacto]

No I have all the text in Excel..

I'm not sure if they are lost - Firefox just wont show them... telling me there is an error.

 

[Norie]

Anders

Firefox?

What exactly is this XML file for?

 

[exAHSacto]

I create the XML file in VBA, view it using Notepad++ AND Firefox or XML Notepad.

The XML file is for XBRL...

 

[Norie]

Have you tried viewing or loading it into whatever application that it's meant for?

 

[exAHSacto]

Nope and it is not possible for the next for months