![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
<\/H2>\n <\/H2>\nHey, Scripting Guy! I have really been enjoying the recent Windows PowerShell articles on the Script Center. I am wondering if it is possible to use Windows PowerShell to work with a Microsoft Office Word document. Specifically, what I would like to be able to do is to change the paragraph formatting and perhaps add a border. I may be asking too much, but I guess I can always hope.
– DP<\/P>![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
\n
Hi DP,<\/P>\n
I am glad you want to format a paragraph, rather than format say, for instance, your hard disk. If you did format your hard disk, you would not have any more paragraph problems. But then just because you can do something, does not mean you should do something. So maybe you better not format your hard drive\u2014at least not yet. <\/P>\n
Rather than opening up the Word document and then selecting the paragraphs and the changing the font size and then highlighting the last sentence and then selecting the border icon, we need to come up with a way to automate this process in Word. In fact, after spending an hour on the treadmill trying to format my stomach, I came up with the FormatWordParagraph.ps1<\/B> script. I am still working on the FormatStomach.ps1<\/B> script (so far, I have been unable to come up with a good API to use, other than the treadMill API, which, while it works pretty good, is rather difficult to use). Here is the FormatWordParagraph.ps1<\/B> script. (By the way, there is a VBScript here<\/A> that works with Word that might be interesting to look at for comparison. In addition, there are quite a few VBScripts for Microsoft Office in the Script Center Script Repository<\/A>. You may want to take a look at the Script Repository’s home page<\/A> as well.) <\/P>\n FormatWordParagraph.ps1<\/B><\/P> Well, DP, this script is about as difficult as falling off a boat with 50 pounds of scuba gear strapped on. After you get your momentum going, it just happens. As they said while I was diving in the Little Caymans two weeks ago, “pool’s open” (not sure why they say that, it must be Caymanian for “get your happy butt off my boat.”) The pool’s open\u2014let’s dive in. But before we do, here’s the Word document we are going to work on:<\/P> <\/P>\n The first line of code is very simple. We simply assign a string that represents the path to the file we want to open. Remember in Windows PowerShell we use a dollar sign in front of all variables. This makes it easy to know that we are working with a variable. This is seen here: <\/P> The next thing we need to do is to create an instance of the word.application<\/B> object. To do this, we use the New-Object<\/B> cmdlet and use the -comobject<\/B> parameter to create the object. We store the returned object in the $word<\/B> variable as seen here: <\/P> When we have a copy of the word.application<\/B> object, we can use it in many different ways. Here is the documentation on MSDN<\/A> that discusses this object. Stay tuned for more “Hey, Scripting Guy!” articles using some of these methods. <\/P>\n Now we have a decision to make, DP. Do you want to see what is going on or not? This is not necessarily a rhetorical question. In our script, we are making it visible because it makes for an interesting demo. However, if you want to modify several hundred Word documents, watching the show would be more boring than an old Car 54, Where Are You?<\/A> rerun. To make the Word document visible, we simply set the visible property to be equal to $true<\/B> as seen here: <\/P> Then we need to open the document: <\/P> Next we need to get the collection of paragraphs: <\/P> After we have the paragraphs collection, we indent the first line of each paragraph by two spaces. This is easy to do: <\/P> Now for something that is very cool with Windows PowerShell. It looks a little bit ugly, but it is very cool nonetheless. We are going to use Word enumeration values for border line style<\/A>, border color<\/A>, border width<\/A>, and border type<\/A> (but not border collie<\/A>): <\/P> What is so cool about being able to use enumeration values? Let\u2019s look at one of the enumerations in Table 1. As you can see in Table 1, Word defines a number of values that are used to control the width of a line that is used for the border. In VBScript, you would typically create a constant and assign the number from the value column, and then use it in the script. In VB.NET or in C#, you would use the enumeration directly. In Windows PowerShell, we can also use the enumeration. For each of the enumeration types we create, we place the name of the type, and then we use the -as<\/B> operator to tell it we want to use the variable as a particular type. Even though the code may look a little confusing, all we really did was copy the name of the enumeration we found in MSDN, and then assign it to the variable as a type. <\/P>\n Table 1 WdLineWidth Enumeration Values <\/B><\/P>\n wdLineWidth025pt<\/P><\/TD>\n 2<\/P><\/TD>\n 0.25 points<\/P><\/TD><\/TR>\n wdLineWidth050pt<\/P><\/TD>\n 4<\/P><\/TD>\n 0.50 points<\/P><\/TD><\/TR>\n wdLineWidth075pt<\/P><\/TD>\n 6<\/P><\/TD>\n 0.75 points<\/P><\/TD><\/TR>\n wdLineWidth100pt<\/P><\/TD>\n 8<\/P><\/TD>\n 1.00 points (default)<\/P><\/TD><\/TR>\n wdLineWidth150pt<\/P><\/TD>\n 12<\/P><\/TD>\n 1.50 points<\/P><\/TD><\/TR>\n wdLineWidth225pt<\/P><\/TD>\n 18<\/P><\/TD>\n 2.25 points<\/P><\/TD><\/TR>\n wdLineWidth300pt<\/P><\/TD>\n 24<\/P><\/TD>\n 3.00 points<\/P><\/TD><\/TR>\n wdLineWidth450pt<\/P><\/TD>\n 36<\/P><\/TD>\n 4.50 points<\/P><\/TD><\/TR>\n wdLineWidth600pt<\/P><\/TD>\n 48<\/P><\/TD>\n 6.00 points<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n Now we want to change the font of our paragraphs. To do this, we use the Foreach<\/B> statement, because the paragraphs<\/B> property returns a collection of paragraphs. Just like in VBScript, we need to iterate through the collection, so we use Foreach<\/B>. We use the variable $paragraph<\/B> to represent one paragraph out of the collection. The font size is found in the Range.font.size<\/B> property. We set this value equal to 10. The curly brackets indicate we have a code block. That is, the $paragraph.Range.font.size = 10<\/B> code will be repeated once for each paragraph in the collection of paragraphs. This section of code is seen here: <\/P> To set the border on the first paragraph, we use the item<\/B> method from the paragraph collection that is held in the $paragraphs<\/B> variable. We choose the first paragraph by supplying 1 to the item<\/B> method. Now we get the borders collection by using the borders<\/B> property, and again use the item<\/B> method to retrieve a specific border. The border we want to draw is the bottom border. To do this we use the wdBorderBottom<\/B> enumeration from the wdBorderType<\/B> enumeration. We have stored this enumeration type in the variable $borderType<\/B>. The secret here is the use of the double colon (::<\/B>) to get our specific enumeration. This line of code is seen here: <\/P> Next we use the enumerations we created earlier to supply the line style, the color, and the width of the bottom border we will draw. Notice that we use the same syntax, the property of the border, the enumeration, the double colon, and then the actual enumeration name that was taken from MSDN. This section of code is shown here: <\/P> Now we need to make the border visible. This works exactly the same way it would in VBScript: You set the visible property of the border to true<\/B>. This is seen here: <\/P> Finally, we want to save our changes, and quit Word. To do this we use the save<\/B> method and the quit<\/B> method. The only hard part here is that you save the document and you quit the Word application.<\/P>\n Important note<\/B>: If you make the Word application invisible with $word.visible = $false<\/B>, and you forget to quit Word, you can end up with multiple instances of winword.exe<\/B> running on your system. If you are working with hundreds of Word documents\u2026well, let\u2019s just say you probably will not quite make it through hundreds of Word documents before your work station falls off the desk gasping for air and whining about lack of . <\/P> You can see the newly modified Word document here:<\/P> <\/P>\n So, DP, I hope this helps you with your Word paragraph and border problems. Stay tuned for more Word fun next time. Until then, take care.<\/P>\n Ed Wilson and Craig Liebendorfer, Scripting Guys<\/B><\/B><\/SPAN><\/FONT><\/P><\/B><\/FONT><\/p>\n","protected":false},"excerpt":{"rendered":" Hey, Scripting Guy! I have really been enjoying the recent Windows PowerShell articles on the Script Center. I am wondering if it is possible to use Windows PowerShell to work with a Microsoft Office Word document. Specifically, what I would like to be able to do is to change the paragraph formatting and perhaps add […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[84,49,3,45,395],"class_list":["post-54943","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-word","tag-office","tag-scripting-guy","tag-windows-powershell","tag-word-application"],"acf":[],"blog_post_summary":" Hey, Scripting Guy! I have really been enjoying the recent Windows PowerShell articles on the Script Center. I am wondering if it is possible to use Windows PowerShell to work with a Microsoft Office Word document. Specifically, what I would like to be able to do is to change the paragraph formatting and perhaps add […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/54943","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=54943"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/54943\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=54943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=54943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=54943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}$filePath = “c:\\fso\\test.doc”\n$word = New-Object -comobject word.application\n$word.visible = $true\n$doc = $word.documents.open($filePath)\n$paragraphs = $doc.paragraphs\n$paragraphs.indentFirstLineCharWidth(2)\n$lineStyle = “microsoft.office.interop.word.wdlLineStyle” -as [type]\n$colorIndex = “microsoft.office.interop.word.wdColorIndex” -as [type]\n$lineWidth = “microsoft.office.interop.word.WdLineWidth” -as [type]\n$borderType = “microsoft.office.interop.word.wdBorderType” -as [type]\nForeach($paragraph in $paragraphs)\n{\n $paragraph.Range.font.size = 10\n}\n $border = $paragraphs.item(“1”).borders.item($borderType::wdBorderBottom)\n $border.lineStyle = $lineStyle::wdLineSingle\n $border.ColorIndex = $colorIndex::wdAuto\n $border.lineWidth = $lineWidth::wdLineWidth225p\n $border.visible = $true\n$doc.save()\n$word.quit()<\/PRE>\n![\"Image](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/hsg\/hey1106\/hsg_wordparagraph1.jpg\")
\n$filePath = “c:\\fso\\test.doc”<\/PRE>\n
$word = New-Object -comobject word.application<\/PRE>\n
$word.visible = $true<\/PRE>\n
$doc = $word.documents.open($filePath)<\/PRE>\n
$paragraphs = $doc.paragraphs<\/PRE>\n
$paragraphs.indentFirstLineCharWidth(2)<\/PRE>\n
$lineStyle = “microsoft.office.interop.word.wdlLineStyle” -as [type]\n$colorIndex = “microsoft.office.interop.word.wdColorIndex” -as [type]\n$lineWidth = “microsoft.office.interop.word.WdLineWidth” -as [type]\n$borderType = “microsoft.office.interop.word.wdBorderType” -as [type]<\/PRE>\n
\n\n
\n \nName<\/TD>\n Value<\/TD>\n Description<\/TD><\/TR><\/THEAD>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n <\/DIV>\nForeach($paragraph in $paragraphs)\n{\n $paragraph.Range.font.size = 10\n}<\/PRE>\n$border = $paragraphs.item(“1”).borders.item($borderType::wdBorderBottom) <\/PRE>\n
$border.lineStyle = $lineStyle::wdLineSingle\n $border.ColorIndex = $colorIndex::wdAuto\n $border.lineWidth = $lineWidth::wdLineWidth225p<\/PRE>\n
$border.visible = $true<\/PRE>\n
$doc.save()\n$word.quit()<\/PRE>\n
![\"Image](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/hsg\/hey1106\/hsg_wordparagraph2.jpg\")
\n