Two ways come to mind:
1) You can use double  double quotes, as follows: mystr = "=========I
Love ""VBA""===============" - although I might have the format
incorrect, the idea is correct.
2) Programmatically find and replace all "VBA" with _VBA_, do your
comparison, and replace _VBA_ with "VBA" before reporting. May sound
long-winded, but for me at least, much easier than the first.