Adding bulk AutoCorrect entries to Word<\/h2>\n
There is not much difference between adding bulk AutoCorrect entries or adding a single entry to the AutoCorrect feature. The same “overhead” applies associated with creating the Word.Application object and releasing the Word.Application object. The big difference is that entering a single entry from a command line or hardcoded into the script is a workable solution. With more than two or three entries, such a technique no longer remains viable. Therefore, storage of the bulk entries is a paramount design consideration for a script of this type. Because I might want to remove my bulk entries, I decided to write a single function to add or to delete bulk AutoCorrect entries.<\/p>\n
Use a CSV file for storage<\/h2>\n
Perhaps the easiest way to add bulk AutoCorrect entries to Microsoft Word is to use a comma separated value (CSV) file to store the entries. Of course, XML is also a possibility, as would be an Access database, or a Microsoft Excel spreadsheet. But like I said, I am looking for the easiest storage, and there is nothing wrong with a CSV file, and Windows PowerShell makes working with CSV files very easy. To read a CSV file use the Import-CSV<\/b> cmdlet and specify a path to the CSV file. For my CSV file, I used the same column headings that Microsoft Word uses in the graphical interface. Replace<\/i> is the word to replace, and with <\/i>is the word that makes the substitution. Part of the real power of this methodology is that I can substitute a few letters such as lol <\/i>with a phrase such as laugh-out-loud. This can greatly reduce your typing requirements. My sample CSV file is shown here.<\/p>\n
The beginning portion of my Set-AutoCorrectEntries<\/b> function defines parameters for the path to the CSV file, and switched parameters that determine whether to add or to remove the entries from Microsoft Word. This portion of the function is shown here.<\/p>\n Function Set-AutoCorrectEntries<\/p>\n {<\/p>\n Param(<\/p>\n [string]$path,<\/p>\n [switch]$add,<\/p>\n [switch]$remove)<\/p>\n $entry = Import-Csv -Path $path<\/p>\n Next, I create the Word.Application object, do not make it visible, and obtain the AutoCorrect.entries<\/b> object. This portion of the script is shown here.<\/p>\n $word = New-Object -ComObject word.application<\/p>\n $word.visible = $false<\/p>\n $entries = $word.AutoCorrect.entries<\/p>\n Now I determine if the function is to add or to delete the entries. If add, I use the ForEach<\/b> <\/i>language statement to walk through the collection of entries in the $entry<\/b> variable (the result of importing the CSV file). I now use Try <\/b>\/ Catch<\/b> to provide basic error handling. In the Try<\/b> scriptblock, I attempt to add the item to the entries collection from the AutoCorrect object. I use the Catch<\/b> scriptblock, to catch any errors that arise and display the name of the replacement item that fails to add. This portion of the script is shown here.<\/p>\n if($add)<\/p>\n {<\/p>\n Foreach($e in $entry)<\/p>\n {<\/p>\n Try<\/p>\n { $entries.add($e.replace, $e.with) | out-null }<\/p>\n Catch [system.exception]<\/p>\n { “unable to add $($e.replace)” }<\/p>\n } #end foreach<\/p>\n }#end if add<\/p>\n It takes a while to delete all the entries from the AutoCorrect entries object in Word. Therefore, I decide to use the Write-Progress<\/b> cmdlet to produce a progress bar that indicates the status of the delete operation. I only add this progress bar to the Remove<\/b> <\/i>portion of the function because the Add<\/b> portion completes quickly. First, I need to initialize the $j<\/b> variable (used as a counter) to ensure that the correct percentage completion displays. Next, I use the ForEach<\/b> <\/i>language statement to walk through the entries stored in the $entry<\/b> variable. I next increment the $j<\/b> variable, and call the Write-Progress<\/b> cmdlet. When this portion of the script runs, the dialog box shown here displays (if the script runs from within the Windows PowerShell ISE).<\/p>\n The portion of the script that begins the Remove<\/b> operation and displays the progress bar is shown here.<\/p>\n if($remove)<\/p>\n { $j = 0<\/p>\n Foreach($e in $entry)<\/p>\n { $j = $j+1<\/p>\n Write-Progress -Activity “deleting entries” -Status “deleting $($e.replace)” `<\/p>\n -percentcomplete ($j\/$entry.count*100)<\/p>\n To delete the entries in the AutoCorrect entries requires using the Delete<\/b> <\/i>method from the entries collection. To call this method, it is necessary to match an entry from the $entry<\/b> collection that is created by reading the CSV file with an entry in the entries collection. This requires walking through the CSV file contents and the entries in the entries collection. When a match occurs, I call the Delete<\/b> <\/i>method. This portion of the script is shown here.<\/p>\n foreach($i in $entries)<\/p>\n {<\/p>\n if($i.name -eq $e.replace)<\/p>\n { $i.delete() } }<\/p>\n } #end foreach entry<\/p>\n } #end if remove<\/p>\n The last thing to do is to close word and clean up. This code appears here.<\/p>\n $word.Quit()<\/p>\n $word = $null<\/p>\n [gc]::collect()<\/p>\n [gc]::WaitForPendingFinalizers()<\/p>\n } #End function Set-AutoCorrectEntries<\/p>\n The complete AddRemoveAutoCorrectEntries.ps1 script appears here.<\/p>\n AddRemoveAutoCorrectEntries.ps1<\/b><\/p>\n Function Set-AutoCorrectEntries<\/p>\n {<\/p>\n Param(<\/p>\n [string]$path,<\/p>\n [switch]$add,<\/p>\n [switch]$remove)<\/p>\n $entry = Import-Csv -Path $path<\/p>\n $word = New-Object -ComObject word.application<\/p>\n $word.visible = $false<\/p>\n $entries = $word.AutoCorrect.entries<\/p>\n if($add)<\/p>\n {<\/p>\n Foreach($e in $entry)<\/p>\n {<\/p>\n Try<\/p>\n { $entries.add($e.replace, $e.with) | out-null }<\/p>\n Catch [system.exception]<\/p>\n { “unable to add $($e.replace)” }<\/p>\n } #end foreach<\/p>\n }#end if add<\/p>\n if($remove)<\/p>\n { $j = 0<\/p>\n Foreach($e in $entry)<\/p>\n { $j = $j+1<\/p>\n Write-Progress -Activity “deleting entries” -Status “deleting $($e.replace)” `<\/p>\n -percentcomplete ($j\/$entry.count*100)<\/p>\n foreach($i in $entries)<\/p>\n {<\/p>\n if($i.name -eq $e.replace)<\/p>\n { $i.delete() } }<\/p>\n } #end foreach entry<\/p>\n } #end if remove<\/p>\n $word.Quit()<\/p>\n $word = $null<\/p>\n [gc]::collect()<\/p>\n [gc]::WaitForPendingFinalizers()<\/p>\n } #End function Set-AutoCorrectEntries<\/p>\n One thing to keep in mind, entries added to the AutoCorrect entries collection remain after closing Microsoft Word. But if Microsoft Word remains open during the process of adding or removing entries, the AutoCorrect entries do not update until after closing and reopening Microsoft Word.<\/p>\n Well, that is about all there is to using a CSV file to add or to delete entries for the AutoCorrect feature in Microsoft Word. This also concludes Microsoft Word Automation Week. Join me tomorrow for more cool Windows PowerShell stuff as I create a function to copy stuff from one Windows PowerShell ISE tab to a new one. This function is so cool that I added it to my Windows PowerShell ISE profile.<\/p>\n I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n Ed Wilson, Microsoft Scripting Guy<\/b><\/p>\n","protected":false},"excerpt":{"rendered":" Summary: Microsoft Scripting Guy, Ed Wilson, shows how to use Windows PowerShell and a CSV file to add bulk AutoCorrect entries to Microsoft Word. Microsoft Scripting Guy, Ed Wilson, is here. Microsoft TechEd 2012 in Orlando, Florida is over—well, basically over. Luckily, the Scripting Wife and I were invited by one of the Windows PowerShell […]<\/p>\n","protected":false},"author":596,"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],"class_list":["post-9041","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-word","tag-office","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":" Summary: Microsoft Scripting Guy, Ed Wilson, shows how to use Windows PowerShell and a CSV file to add bulk AutoCorrect entries to Microsoft Word. Microsoft Scripting Guy, Ed Wilson, is here. Microsoft TechEd 2012 in Orlando, Florida is over—well, basically over. Luckily, the Scripting Wife and I were invited by one of the Windows PowerShell […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/9041","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\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=9041"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/9041\/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=9041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=9041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=9041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/0676.HSG-6-15-12-01.png\" "\\"Image")
<\/a><\/p>\nUse the Add method to add the entries<\/h2>\n
Use the Delete method to remove entries from AutoCorrect<\/h2>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/0815.HSG-6-15-12-02.png\" "\\"Image")
<\/a><\/p>\n