The text file seems to be encoded as 65001 (unicode (UTF-8)).
For the moment, in the attached, is an alternative solution, using Power Query. As it is I've left it looking at the most recent file you attached. Before it looks at your text file on your system, you need to point the query at that file.
This picture attempts to show you what you need to do: 2020-08-28_133518.jpg
I've also attached the picture as a zip file in case the resolution's not good enough.
After that has been done, you only need to right-click the table and choose Refresh which will update the table according to what's in the text file on your system.
I will still try and tweak the macro solution to read this 65001-encoded text file - but I'm out of time just now.
I'm interested, where does this text file come from?
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote