VBA to Import text file

[ionelz]

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

 

[ionelz]

My command button is is Sheet1
But import text file I want to go to sheet2
Post #9 works great, but I have changed one line (to sheet2)

Set sh1 = ThisWorkbook.Sheets(2)

I want this to apply to sheet2
Range("C4:C1000").ClearContents
but since my command button is in sheet1 it clear in sheet1
how to fix this !? how to say that Range("C4:C1000").ClearContents apply to sheet2

 

[DanteAmor]

After this line:
Set sh1 = ThisWorkbook.Sheets(2)

Put this:
sh1.Range("C4:C1000").ClearContents

 

[jdellasala]

Seems like a better answer would be to pull it in using Power Query....