Hi,
I would like to be able to import a VERY large text file, more then 50,000 lines
Every line from text file should go in one cell so result should be in one column in excel
Text file looks like :
========================
******textttttttttttttttttttt hhhhhhhhhhh++++++++++++++
klsfkg;ldasg
eiwotqwthwqo
lDL;ahdlad
###########
lasflhaslfhaldgdg
hasdjakshfjkasf35959032463406
What ever I found on net (VBA to import text file) do not work,
Redardless of size, I get error like out of memory
I would like to be able to import a VERY large text file, more then 50,000 lines
Every line from text file should go in one cell so result should be in one column in excel
Text file looks like :
========================
******textttttttttttttttttttt hhhhhhhhhhh++++++++++++++
klsfkg;ldasg
eiwotqwthwqo
lDL;ahdlad
###########
lasflhaslfhaldgdg
hasdjakshfjkasf35959032463406
What ever I found on net (VBA to import text file) do not work,
Redardless of size, I get error like out of memory