OPEN TEXT then WRITE TEXT Unicode incorrect

In a nutshell, I am using the OPEN FOR OUPUT method to create a text file, then I'm reading another text file line by line and only adding lines to the new file if it does not have any of the exclusion text strings in it.l

Then I write out the new file.

The problem is that 7 out of 10 files created this way end up looking like chinese characaters when I open them in a text editor. I have to manually set the text file encoding to UTF-8, it appears that a huge portion of them are ending up UTF-16 encoding.

So, how do write out the final file from within VBA forcing the UTF-8? Googling is coming up with difficult answers.

Abridged:

Please Login or Register  to view this content.

Are those some Print options I'm not aware of to insure the resulting text file is forced to be UTF-8?

Hey Jerry,

This sounds like a Power Query problem to me. When you open the file, there are lots of options to import the data. See all the options:
https://docs.microsoft.com/en-us/pow...p-data-sources

Filtering out rows that contain strings is also easy using PQ using Text Filter of Contains.

Have you tried your data in PQ yet?

Zero exp with that. I was really hoping to not toss 100s of lines of coding for a whole new macro....

Adodb

Have you looked Here

I have this off the shelf, JB, and I'm off to bed.

Please Login or Register  to view this content.

Thanks guys, this is what I needed, a little good-old-fashioned-handholding. Cheers!