Good catches. Fixed
Good catches. Fixed
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
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?