title: Automatically Replace Misspellings with Suggestions for long lists of terms
body: <p>I have a long list of terms.  Over 90% are misspellings.  Most of which are two words that have no space in the middle.  I noticed that MS Word, Excel, Office, etc. is pretty good at suggesting the correct spelling.  When I run the spellchecker, I don't have time to confirm each and every suggested correction.  Having some errors are OK.</p>
  
  <p>How can I automate spellcheck, or rather "spellcorrect" without prompting?  I don't mind using  other tools besides Microsoft, but it's spellchecker seems pretty good.  I tried some VBA code to use with Excel, but I can't find anything that will programmatically show me the main suggestion so that I can replace the misspelled term.</p>
  
  <pre><code>Sub spellcheck()
  
  
      With Application.SpellingOptions
          .SuggestMainOnly = True
          .IgnoreCaps = True
          .
      End With
  
      Cells.CheckSpelling
  
  End Sub
  </code></pre>
  
  <p>Any help is appreciated.  And please I understand the danger of auto-correct.  The impact of wrongful corrections is minimal.</p>
  
  <p>Thanks, 
  Steve</p>