Random header image... Refresh for more!

Archive for the ‘Microsoft Office’ Category

Insert a Page Break in a Word Document using PowerShell

Icon Written by Niklas Goude on March 15, 2009 – 11:15 pm

I got this idea from “dmtelf” who posted a comment on a previous post I wrote regarding Microsoft Word and PowerShell. I ran through a few tests and this is the result.

First, lets Insert a Page Break after every Paragraph in a Word Document. The script will insert a Page break after each Paragraph. I’ve [...]

Tags:

Replacing text in Word documents through PowerShell

Icon Written by Niklas Goude on February 5, 2009 – 11:24 pm

In a previous migration project, we had some issues with Word documents, actually a couple of thousand Word documents containing Server names pointing to the old servers.. In other words, after the migration, all these word documents would point to the wrong server. Changing this manually would take weeks. Changing the documents through PowerShell would [...]

Tags:

Edit Excel SpredSheet through PowerShell

Icon Written by Niklas Goude on February 5, 2009 – 12:31 pm

A friend at my company just asked me how to modify a Excel Spredsheet based on a template and save it as a new Excel spredsheet through PowerShell. Looking inot this, There where some issues when trying to close the Excel file through PowerShell. After a little research I found an article by Hristo Deshev [...]

Tags: