How to set spelling language for Application.CheckSpelling method?

Be4ep used Ask the Experts™
I tried to set MainDictionary as ActiveSpellingDictionary of other not default Language but checkspelling verifies with default language anyway.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006
Hello Be4ep,

that will indeed not work as the language setting of the document text determines the dictionary used in the spellcheck

check out this post with code

it's a bit much but clear code, let me know


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial