Including special characters in Excel generated XML

I have a problem with the following:

Previously I got help from one of the Excelforum users in generating an XML based on a specific schema.
However this solution had a fault; the XML being generated did not support special characters (such as "ä","ö","å" and even "&").

Could somebody kindly help me with this issue?

The Module for generating XML is below and an example excel file along with the target XML schema attached.

Please Login or Register  to view this content.