https://quadexcel.com/wp/excel-vba-tutorial-110-reading-input-from-a-text-file/
Excel VBA Tutorial 110 - Reading input from a text file