Hi,

My purpose is create a macro that writes a XML file.

I have created a file text with several Print #, string commands.
In fact, it is a text file with .xml extension, and I have put in the first line the tag <?xml version='1.0' encoding='UTF-8' ?>, because I want this document to be encoded that way.

What happens is that I think that the way I create the file doesn't use the UTF8 encoding, so when I try to open the XML file with Internet Explorer I get an error (I use some special characters, as &iacute because there are problems with some characters.

I would like to know how to create a file with UTF-8 encoding, or the other option would be how to change the encoding of an existing file (even better!). In both cases, I need to do all these thing via an excel macro (vba).

I have spent several days surfing the web and I'm beginnig to desperate!!!!

Thanks in advance