When a string is fed into a text box or a variable, does it go with the quotes "", is there any way I can remove them...so that if its: "mystring" it becomes mystring...
Printable View
When a string is fed into a text box or a variable, does it go with the quotes "", is there any way I can remove them...so that if its: "mystring" it becomes mystring...
VB Code:
sMyString = """MyString""" sMyString = Replace$(sMyString, """", vbNullString, 1, 1) If Right$(sMyString, 1) = """" Then sMyString = Left$(sMyString, Len(sMyString) - 1) End If