I found some code written by Chip Pearson that allows importing a large text file into Excel. I tried it on a file that was nearly 400mb and got an Error14 when I tried to convert vbLf to vbCr in one of his functions (which tries to load the entire text file into one string). Does anyone know a work around?

Thanks.