With using Redim and without hardcoding the array size and compile time, your only option, using arrays, is:
Dim myArray( i ) As String
where
i
is a variable that is set somewhere that contains of the size of the array at runtime.
You're other, and more flexible option, would be to use a generic collection of Strings.
Dim myStrings As New List(Of String)
There's no need to define its capacity at all.