View Single Post
Old March 30th, 2007, 09:44 AM
BrianWren BrianWren is offline
Friend of Wrox
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

It converts only the first character...

ASC() returns the value of one character. It disregards the rest. So you will have to write the code to pass one character at a time, and keep track of the values received, also one at a time.
    Dim s As String
    Dim i As Integer
    s = "ABCD"
    For i = 1 to Len(s)
        <catch your value here> = ASC(Mid$(s, i, 1))
    Next i
    But what to do with the value is up to you. Myself, I can see no value to doing something like this. The result is altogether meaningless...

What are you trying to accomplish? I'm quite sure there's a better way...