Eliminating characters from fields

[JoanieB]

Not using crappy macro "send keys": how can certain characters [ie quotes] be removed from string (or from the field itself before pulling into VBA code as a string)?

 

[MichaelRed]

MyStr = "this is a String " & CHr(34) & Chr(34) & "With Embeded "
? MyStr
this is a String ""With Embeded
? Replace(MyStr, Chr(34), "&quot
this is a String With Embeded

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over