try using the Replace function after it is copied to the string

ie
Dim Clip as string

'after copying the clipboard to the string
Clip = replace(Clip, chr(34),"")

Have a good one