String.SubString problem

[Ljuslykta]

Hi.

I've got a problem with SubString. I'm trying to send over a few variables, and i separate them with !. The code looks like this.

While Not returndata.Substring(A, 1) = "!"
TEST = TEST & returndata.Substring(A, 0)
MsgBox(TEST)
A = A + 1
End While

returndata is the string witch holds the variables.
A starts at 0, and then check after a ! in returndata.

When I run this, I get an error.

Index and length must refer to a location within the string.

 

[PlausiblyDamp]

Wouldn't it just be easier to use the .Split method instead of trying to split it yourself?

 

[Ljuslykta]

How does it work?

 

[PlausiblyDamp]

http://msdn.microsoft.com/en-us/library/b873y76a.aspx