How to invoke spellchecker in VBA to check a string?

K

KR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top