I have a CSV file that will parse and put in an Array this is a DYNAMIC ARRAY after that I will get the difference between the two Arrays but I can't proceed in my computation because my second array can't get the value.
This is what i have got so far
Option Explicit
Private Sub cmd_parse_Click()
Dim adata() As String
Dim time1() As String
Dim holder1, holder2
Dim time2() As String
Dim lngIndex As Integer
Dim totaltime() As String
Do Until ft1.AtEndOfStream
On Error Resume Next
a = ft1.ReadLine
b = a
p(0) = a
r = r + 1
Text1.Text = r
z = Left(b, 1)
adata = Split(a, ",")
If Not IsNumeric(z) Then
For i = 0 To UBound(adata)
Text3 = adata(i)
If Text3 <> "Time Stamp" Then
ft2.WriteLine Text3
End If
Next
Else
If holder1 = "" Then
time1 = Split(a, ",")
For lngIndex = 0 To UBound(time1)
holder1 = time1(lngIndex)
Next lngIndex
Else
time2 = Split(a, ",")
For lngIndex = 0 To UBound(time2)
holder2 = time2(lngIndex)
Next lngIndex
End If
'subtract array time1 from time2
If holder1 <> "" And holder2 <> "" Then
For lngIndex = 0 To UBound(time2)
holder3 = time2(lngIndex) - time1(lngIndex)
Next lngIndex
End If
End If
DoEvents
Loop
Can somebody help me please.