Hi,
Is there a way i can create an array with no bound like so (FieldSep being the array) -
The problem i get is i need to declare it i.e
which mean if i cnt is less than 100 it puts everything as default and if cnt is more than 100 it fails as script out of range. How can i just let it keep adding to itself so i dont have to declare how bit it is. It just does it itself
Thanks
k0r54
Is there a way i can create an array with no bound like so (FieldSep being the array) -
Code:
Do
pnt = InStr(stp, ary, " ") - 1
FieldSep(cnt) = Array(pnt, fmt)
stp = pnt + 2
cnt = cnt + 1
Loop While InStr(stp, ary, " ") <> 0 Or stp > Len(ary)
The problem i get is i need to declare it i.e
Code:
Dim FieldSep(100) as string
which mean if i cnt is less than 100 it puts everything as default and if cnt is more than 100 it fails as script out of range. How can i just let it keep adding to itself so i dont have to declare how bit it is. It just does it itself
Thanks
k0r54