I have a word generator that creates various combinations of letters
but I only want to process words that would pass a spell check. Is
there a VBA function that can operate on a string to check its
spelling? I want this to be totally automated, not the CheckSpelling
method that brings up a dialog on misspelled words. I want to skip
misspelled words, not correct them.

The Application.CheckSpelling method returns True if the word is found
in Excel's dictionary, False otherwise.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Note that you have to use Application.CheckSpelling, the other
variations will bring up the dialog box.

--JP

On Oct 21, 2:08*pm, Edward wrote:
I have a word generator that creates various combinations of letters
but I only want to process words that would pass a spell check. *Is
there a VBA function that can operate on a string to check its
spelling? *I want this to be totally automated, not the CheckSpelling
method that brings up a dialog on misspelled words. *I want to skip
misspelled words, not correct them.

On Oct 21, 2:20*pm, JP wrote:
The Application.CheckSpelling method returns True if the word is found
in Excel's dictionary, False otherwise.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Note that you have to use Application.CheckSpelling, the other
variations will bring up the dialog box.

--JP

On Oct 21, 2:08*pm, Edward wrote:



I have a word generator that creates various combinations of letters
but I only want to process words that would pass a spell check. *Is
there a VBA function that can operate on a string to check its
spelling? *I want this to be totally automated, not the CheckSpelling
method that brings up a dialog on misspelled words. *I want to skip
misspelled words, not correct them.- Hide quoted text -

- Show quoted text -

Bingo! Thanks.

You're welcome!

--JP

On Oct 21, 2:39*pm, Edward wrote:

Bingo! *Thanks.