title: Need regular expression expert: round bracket within stringliteral
body: <p>I'm searching for strings within strings using Regex. The pattern is a string literal that ends in <code>(</code>, e.g.</p>
  
  <pre><code># pattern
  " before the bracket ("
  
  # string
  this text is before the bracket (and this text is inside) and this text is after the bracket
  </code></pre>
  
  <p>I know the pattern will work if I escape the character with a backslash, i.e.:</p>
  
  <pre><code># pattern
  " before the bracket \\("
  </code></pre>
  
  <p>But the pattern strings are coming from another search and I can not control what characters will be or where. Is there a way of escaping an entire string literal so that anything between markers is treated as a string? For example:</p>
  
  <pre><code># pattern
  \" before the ("
  </code></pre>
  
  <p>The only other option I have is to do a substitute adding escapes for every protected character.</p>
  
  <hr>
  
  <p>re.escape is exactly what I need. I'm using regexp in Access VBA which doens't have that method. I only have replace, execute or test methods. </p>
  
  <p>Is there a way to escape everything within a string in VBA?</p>
  
  <p>Thanks</p>