View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KR KR is offline
external usenet poster
 
Posts: 121
Default How to invoke spellchecker in VBA to check a string?

I want to create pnemonic strings to help remember telephone numbers. I set
up a program that will run through every possible character combination of
the 3 letters on numbers 2-9 and return every possible 7-character string
(about 2200 total for each 7-digit phone number), but of course most of what
it returns is gibberish.

How can I invoke the spellchecker (as used within Excel) but send it my
strings, and reject any 7-letter string that isn't recognized in the
spellchecker dictionary? That way I can only populate my worksheet with the
strings that might make (better) pnemonics.

Code snippets greatly appreciated!

Many Thanks,
Keith


--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.