How to search for a string that includes the " symbol

[jonrayworth]

Hi,

I'm writing some VB in an Excel macro to search and replace a string of text.

The problem is that the string contains the " symbol, so when Access gets to that symbol it thinks that it's reached the end of the string.

e.g.

I want to replace "0519","863027" (including the quotes) with "0001","863027"


This is what the code looks like, but it obviously doesn't work :

Cells.Replace What:="0519","863027", Replacement:="0001","863027", LookAt:= _
        xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Please could someone let me know what syntax to use so that I can include the quotes in the search string?

Many thanks,
Jon