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.

How to invoke spellchecker in VBA to check a string?
 

Keith

Try here for an example

http://www.dicks-blog.com/excel/2004...ering_tel.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"KR" wrote in message
...
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.