Thank you for the reply. It worked with the exception that my txt file was too long. Is there any way to read an extremely long text file or create an array of the pieces of the text file
too long wow...the string type is capable of handling aprox 2 billion characters...but yes you can read portions using readline or readblock instead of readtoend
Read text file into string
sunrunner
Susan S
.NET will not work in VBA
rbroadbent
Kamarey
Poh Tham
Dim
s As String Dim tr As IO.TextReader = New IO.StreamReader("C:\MyTextFile.txt") s = tr.ReadToEnd