WHAT ????????There are even too many instances when Excel is wrong to go that route.
My suggestions don't involve Excel. You merely need to "escape" the string before you send it to a web service.
Code: Select all
VBSTART
VBEND
Let>FieldValue={"3+1"}
VBEval>escape("%FieldValue%"),FieldValue
Code: Select all
VBSTART
Function t(byref x, byref y, byref z)
z = x + y
t=1
End Function
VBEND
VBEval>y=1,r
VBEval>x=7,r
VBEval>z=0,r
VBEval>t(x,y,z),res
VBEval>z,r