To read a textfile in VBA you can use the following snippet.
to read a textfile line by line see How to read a textfile line by line in VBA.

Sample VBA

Function ReadTextfileComplete(ByVal strFile As String) As String
Dim hFile As Long
    hFile = FreeFile
    Open strFile For Input As #hFile
    ReadTextfileComplete = Input$(LOF(hFile), hFile)
    Close #hFile
End Function