Importing text file to array?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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?action=getinfo&userid=15975
View this thread: http://www.excelforum.com/showthread.php?threadid=467427

.

Relevant Pages

  • RE: Xl2007 Autofilter - ValueList problem
    ... I am not using Advanced filter or filter in place. ... The first part of the code to set the Autofilter works. ... set the filter an array is assigned to Criteria2 then it should be possible ...
    (microsoft.public.excel.programming)
  • Re: using countif in a filtered range
    ... Microsoft Excel MVP ... If we filter on Region 1 ... For this to work we need to generate an array of subtotals, ... In this example we're using SUBTOTAL to count how many cells in the range ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Using Filter string with IF function
    ... Microsoft Excel MVP ... When no filter is set the formula should show a BLANK cell or Display ... Array formulas are entered differently than a regular formula. ...
    (microsoft.public.excel)
  • Re: Elimination of Duplicates in an Array and its reduction.
    ... In Excel 2007, you can probably make a Pivot table with all unique words ... array not having a labels row? ... The filter assumes the first WordA is the column header and the second ... You'll have to copy across to a number of cells that is equal to the ...
    (microsoft.public.excel.misc)
  • Re: Design of FIR filter with Sharp Transition and High Stop BandAttenuation
    ... sampling array that has 4 times as many sample points as the output array. ... So the problem would seem to be a simple matter of devising a filter suitable for downsampling by 4. ... Plus there is some overlap in the light frequencies that each receptor is sensitive to. ... I don't know enough about the structure of his sensor to suggest a scheme, but I think that creating phantom pixels is the right first ...
    (comp.dsp)