VBA Associative Arrays (How to Index)
<p>I'm a newbie to VBA so please forgive my lack of experience.</p>

<p>Im using excel VBA and trying to figure out how to index an array. I'm importing a CSV and using the split function. I need to access each individual items of the items split into the array(s). The best way to explain what I need is an example like this from Actionscript:</p>

<pre><code>var a:Array = [];
a[1] = "Hello";
a[2] = "World";
(Except that what I have is a dynamic array created by the SPLIT function)
Where I could access "Hello" with the var a[1]
</code></pre>

<p>Here is what I have so far:</p>

<pre><code>Sub getTxtfile()
FilePath = Application.GetOpenFilename _
(Title:="Please choose a file to open", _
FileFilter:="CSV Files *.csv* (*.csv*),")
Open FilePath For Input As #1
row_number = 0
Do Until EOF(1)
    Line Input #1, LineFromFile
    LineItems = Split(LineFromFile, ",")
    'ActiveCell.Offset(row_number, 0).Value = LineItems(1)
    'ActiveCell.Offset(row_number, 1).Value = LineItems(0)
    row_number = row_number + 1
    'Debug.Print LineItems(0) &amp; ": " &amp; LineItems(1)
    Loop
Close #1
End Sub
</code></pre>

<p>I now have 2 arrays (LineItems(0) &amp; LineItems(1)) but how do I index what is inside of them at this point?</p>

<p>Thanks for any and all help, it is greatly appreciated.</p>

<p>Mike  </p>

<hr>

<p>The CSV I'm using is formatted to use with other applications SolidWorks, python, etc.) besides Excel. I need to access only certain elements within the array to populate certain cells. As it is...I can pull the entire array into columns but I don't want to do that, just the ones I need. Here is a sample of the CSV:</p>

<p>0,.200 
p,1.0709 
q,1.167 
r,1.177 
s,1.216 
t,1.570 
u,1.5843 
v,1.6883 
w,1.9079 
e,.2645</p>

<p>What I want to do is reference the letter in the first element and have the second element inserted in a certain cell: Reference "t" through an index and have "1.570" inserted.</p>

<p>The elements in my arrays are LineItems(0) and LineItems(1). So ideally I'm looking to reference each indexed item in an element as LineItems(1)(a) / LineItems(1-a) or something similar to that.</p>