Thanks so much! It really works for XML and TXT files now.

I also find some problems are from my XML files which are auto-generated and zipped from SUN Microsystems. I have to unzip, open and save (without change) to make VBA return correct charset.


I am sure if I should open a new post: (I will if you suggest)

(1) Just quick open and save files:
Use ADODB.Stream right? or any better suggestion?

(2) Save with another encoder
Is "ADODB.Stream.Charset" the best way to do it?