' Remove "Illegal" characters
Sub FixString(S As String) As String
' Single Quote replaced with chr(31)
' Double Quote replaced with chr(30)
S=S.Replace("'",Chr(31))
S=S.Replace(Chr(34),Chr(30))
Return S
End Sub
' Restore "Illegal" characters
Sub RestoreString(S As String) As String
' Chr(31) replaced with Single Quote
' Chr(30) replaces with Double Quote, Chr(34)
S=S.Replace(Chr(31), "'")
S=S.Replace(Chr(30),Chr(34))
Return S
End Sub