Importing text file to array?
 

Hello

Is it possible to import text file to array, not to a range? How?
I have a code which import text file to a range (then filter the
imported text), but if the text file is long the code become very slow?
I thought if I import text file directly to the array and then filter
the text in the array, the code will run much faster?
Any suggestions?

Thank you

Dr.Ile


--
Dr.Ile
------------------------------------------------------------------------
Dr.Ile's Profile: http://www.excelforum.com/member.php...o&userid=15975
View this thread: http://www.excelforum.com/showthread...hreadid=467427

Importing text file to array?
 

Dr.Ile,
Can you not query the text file directly with DataGet External Data ?

NickHK

"Dr.Ile" wrote in
message ...

Hello

Is it possible to import text file to array, not to a range? How?
I have a code which import text file to a range (then filter the
imported text), but if the text file is long the code become very slow?
I thought if I import text file directly to the array and then filter
the text in the array, the code will run much faster?
Any suggestions?

Thank you

Dr.Ile


--
Dr.Ile
------------------------------------------------------------------------
Dr.Ile's Profile:
http://www.excelforum.com/member.php...o&userid=15975
View this thread: http://www.excelforum.com/showthread...hreadid=467427

Importing text file to array?
 

I did'n think obout importing external data...thank you


--
Dr.Ile
------------------------------------------------------------------------
Dr.Ile's Profile: http://www.excelforum.com/member.php...o&userid=15975
View this thread: http://www.excelforum.com/showthread...hreadid=467427