help pls

[Aaron Young]

If you're storing data for calulcations why don't you store it in a CSV (Comma Separated Values) fashion,
then you can use the Split() function to extract the values into an Array, i.e.

Dim sData As String
    Dim vLine As Variant
    Dim vValue As Variant
    Dim lLine As Long
        
    sData = FileToString("C:\File.txt")
 
    vLine = Split(sData, vbCrLf)
    For lLine = 0 To Ubound(vLine)
        vValue = Split(vLine(lLine), ",")
        ' Do Whatever with vValue Array
    Next