String Handling

[Guest]

I need to work with a string character by character. Pick off a character,
determine it's ASCII code (using ASC command) , perform some processing, then
move to the next character. I know how to do this in C and may develop this
routine in C but for simplicity sake I would prefer to do everything in VBA.

My problem is moving character by character in the string.

Any help will be appreciated!

 

[Allen Browne]

Dim i As Integer
For i = 1 to Len(MyString)
Debug.Print Asc(Mid(MyString, i, 1))
Next

 

[Guest]

Thanks much! Your speedy reply is appreciated!

Dim i As Integer
For i = 1 to Len(MyString)
Debug.Print Asc(Mid(MyString, i, 1))
Next