>Hi All
>I am new to VBA, as I am a visual foxpro programmer.
>I am trying to write a string to a varible, but the string contains '"'
>ie
>Dim MyString as String
>MyString='this is a test to "test"'
>
>VBA does not seem to like this
>
>So my question is how do I make a string of a sentence that already contains '"'

Dim MyString as String
MyString= "this is a test to " & chr(34) & "test" & chr(34)
? MyString
'  Returns:
'  this is a test to "test"

:) btw chr(39) is the single quote