Probably an easy question, but how do I reference the individual characters of a string? For example in order to extract each character one after another I thought it would be something like this:
Dim MyString As String
Dim MyChar As String
MyString = "abcd"
For index = 0 to Len MyString
MyChar = MyString[index] 'this syntax is incorrect