Reading text files with different Unicode encodings in VBA For an explanation of this solution, please read my blog post: Solving the Unicode, UTF8, UTF16 and Text Files conundrum in VBA. The core of the solution is the GetFileText() function that you'll find in the MTextFile.bas module.