Use VBA to read text from a file
The following simple routine opens a text file, reads each line into a variable, prints it to the Immediate window (press Ctrl+G to see the immediate window in the IDE), then closes the file.
Sub ReadAsciiFile()
Dim sFileName As String
Dim iFileNum As Integer
Dim sBuf As String
' edit this:
sFileName = "C:\temp\test.txt"
' does the file exist? simpleminded test:
If Len(Dir$(sFileName)) = 0 Then
Exit Sub
End If
iFileNum = FreeFile()
Open sFileName For Input As iFileNum
Do While Not EOF(iFileNum)
Line Input #iFileNum, sBuf
' now you have the next line of the file in sBuf
' do something useful:
Debug.Print sBuf
Loop
' close the file
Close iFileNum
End Sub
See How do I use VBA code in PowerPoint? to learn how to use this example code.