Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

re: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

Jack — Wed, 13 Feb 2013 23:20:43 GMT

The example you gave is for spell checking a whole word document. The technique I'm trying to upgrade to PS V3 only spell checks a single word with out displaying the word document. (It's useful for checking input for misspellings within a window form).

I can't find anything to give me a clue why it works in V 2 and not V3.

Thanks for replying.

re: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

JV — Tue, 12 Feb 2013 21:22:32 GMT

@Jack, @ed

I have tested this on XP and Windows 8 with both MSWord 2007 and MSWord 2010.

Here is teh exact code used.

#CheckSpellingAndPrint.ps1

$path = "c:\scripts\test\*"

$word=New-Object -comobject word.application

$word.visible=$true

Get-ChildItem -Path $path -Include *.doc,*.docx |

ForEach-Object{

$_.fullname

$doc=$word.documents.open($_.fullname)

$doc.checkSpelling()

$doc.checkGrammar()

$doc.save()

#$doc.printOut()

$doc.close()

}

$word.quit()

re: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

Jack — Sun, 10 Feb 2013 22:41:21 GMT

Ed, I read your blog, and that command always ran in both modes. It seems like PS 3 does something to the arguments that are being passed to the object. But i haven't found anything on Technet to suggest that the syntax or technique has changed.

I'm curious if you get the same error. I wonder if it's V3 with 2010, or is it V3 with any version of office. What happens when you try it? I wonder if it's just my machine!

Thanks for your time.

re: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

Ed Wilson — Sun, 10 Feb 2013 20:53:36 GMT

@Jack Just a TOTAL GUESS, but check out my blog post blogs.technet.com/.../weekend-scripter-playing-around-with-powershell-namespace-apartmentstate.aspx

re: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

Jack — Sun, 10 Feb 2013 03:34:51 GMT

Thanks for your response!

I figured out that this is a PS version 3 issue. I ran the script with the -version 2.0 switch and it runs.

This is the code:

$oWord=new-object -com Word.Application

[void]$oWord.Documents.Add()

$oWord.CheckSpelling($Word)

_____________________________________________________________________________________

Argument types do not match

At line:1 char:1

+ $oWord.CheckSpelling("spel")

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : OperationStopped: (:) [], ArgumentException

+ FullyQualifiedErrorId : System.ArgumentException

_____________________________________________________________________________________

Any suggestions why version 3 might be doing this?

re: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

Ed Wilson — Sat, 09 Feb 2013 23:32:18 GMT

@Jack there are significant API changes between Office 2007, Office 2010 and even Office 2013. It is always best to go back to MSDN and research these changes. Here is a link to the Word 2010 API documentation. it is where I would start my troubleshooting: msdn.microsoft.com/.../ff837519(v=office.14).aspx

re: Hey, Scripting Guy! How Can I Check Spelling and Grammar in Microsoft Office Word?

Jack — Sat, 09 Feb 2013 23:16:43 GMT

i wrote a spell check function with Office 2007 that worked great. I started testing Office 2010 and found that the spell check function doesn't work. The $oword.checkspelling("word") gets the error "Argument types do not match"

Do you know why this isn't working anymore