title: Find string in doc using wildcards; return full string VBA
body: <p>What I need to do is search a word document for a dollar amount and then return the amount to the program for user verification. I know the amount starts with a "$", and ends with two digits after the decimal point (there's only one amount per document). The search returns true like I want, but how do I actually pull the full figure from the word document (to be assigned to a variable)</p>
  
  <p>Code below (Excel 2010); Cheers.</p>
  
  <pre><code>With wdDoc.Content.Find
     .Text = "$*.??"
     .MatchWildcards = True
     If .Execute Then
        'would be verified here
     Else
        'etc
     End If
  End With
  </code></pre>
  
  <p>Edit:
  I managed to get the following working;</p>
  
  <pre><code>   With wdApp.Selection.Find
        .Text = "$*.??"
        .Wrap = wdFindAsk
        .Forward = True
        .MatchWildcards = True
        If .Execute Then
           debug.print wdApp.Selection.Text
        Else
           debug.print "Not Found"
        End If
     End With
  </code></pre>
  
  <p>The only negative to this is that if the user managed to select a different word document while this search is running, it won't find the result because the selection has changed. Is there any way to specifically search ONLY the active document opened earlier in the code? ("wdDoc"). Using wdDoc.Content doesn't seem to have any way of returning the string.</p>
  
  <p>Edit2: Is there a way to return text from a search using the Word.Document as opposed to the Word.Application?</p>