detecting chars in strings....

is there a short way to check a string for characters. Ie. I want to know if a string contains letters or wether it contains numbers.

isnumeric(Mystring)

is there a short way to check a string for characters. Ie. I want to know if a string contains letters or wether it contains numbers.


Maybe this code wil help:
any invalid character for filenames are changed with a space

For i = 1 To Len(strTempDocName)
k = Asc(Mid(strTempDocName, i, 1))
If Not (k = 45 Or _
k = 46 Or _
k = 95 Or _
(k >= 48 And k <= 57) Or _
(k >= 65 And k <= 90) Or _
(k >= 97 And k <= 127)) Then
strTempDocName = Mid(strTempDocName, 1, i - 1) & " " & Mid(strTempDocName, i + 1)
End If
next