I have a text file which is large and I am reading the file line by line. The
data has some values on each line and it is taking tooo long. I was wondering
if I could load the file to the buffer or read it as one long string which
would speed up the transfer into excel. The file has about 900,000 lines and
I am reading about 40,000.

The process I am using is reading each line then writing it to the excel
spreadsheet. I didn't think it should take 15 minutes to do that. Please help
with tips of reading a text file that can speed up my runs. Thank you in
advance.