Spell Check in Excel-Auto Select First Recommendation

[kellywalters09]

I am looking for some VBA code to be used in Excel VBA that will perform spell check on a selected range on a single Excel worksheet. If a word is found to be misspelled I would like that misspelled word to automatically be changed to the first suggestion that would normally appear in the dialog box. I do recognize the possible data implications but I will be keeping record of the ORIGINAL word for this purpose.

My range could contain up to 30,000 rows of data so the time component is huge here.

Any help is appreciated!

 

[sijpie]

The problem with VBA is that there are no options with CheckSpelling. CheckSpelling will open the spellchecker window. At that moment VBA waits until the window is closed, then it will resume with its code. So from within VBA you cannot interact with the spellchecker window. You will need a C program or similar.

 

[Macropod]

You could automate a Word session, copy the Excel range & paste into a Word document as unformatted text (i.e. so it doesn't generate a table), then use Word's spell-checking tools for what you want to do, writing the corrections back to your workbook. For some relevant Word code, see: http://www.msofficeforums.com/word-...pell-check-correction-without.html#post112057. Do note the caveats there.

 

[Fluff]

Cross posted http://www.vbaexpress.com/forum/sho...el-Auto-Select-First-Recommendation-Using-VBA

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[kellywalters09]

Thanks to all for the help.