Re: Problem regarding ' and "



> For p = 1 To Len(s)
> If Mid(s, p, 1) = Chr(34) Then
> Mid(s, p, 1) = Chr(39)
> End If
> Next


Long way to do this... Take a look a the REPLACE function.


.