| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing CSV file (saved as Text) into XL as Text -- over 60 colu | Excel Discussion (Misc queries) | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
| Basic Q: Field/Array info when importing fixed-width text files | Excel Programming | |||
| Importing text file | Excel Programming | |||
| importing text file, removing data and outputting new text file | Excel Programming | |||
![Dr.Ile[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
