View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_6_] Eric[_6_] is offline
external usenet poster
 
Posts: 23
Default Creating an array

Hi,

I am trying to create a macro that store my text file data
into an array and open it in excel file.

My text file data looks like this:

Column1 Column2
Row1 Name1 TextLength1
Row2 Name2 TextLength2
Row3 Name3 TextLength3
. . .
. . .
. . .

Assuming rows is unlimited, How could I store this data
into an array?

I would appreciate anyone's input, tips or suggestions.

Regards
Eric