Scripting Blog

A place to learn about PowerShell and share stories of automation

Modify the PowerShell ISE to Automatically Add a Script Header

  Summary: Customize the Windows PowerShell ISE by automatically adding custom headers to new scripts. The Microsoft Scripting Guys show you how.   Microsoft Scripting Guy Ed Wilson here. Oliver, my friend in Regensburg, Germany, was having a problem adding a user to a group from another forest. He kept asking me questions when I was...

Automatically Add Comment-Based Help to Your PowerShell Scripts

Summary: Automatically add comment-based help to your Windows PowerShell scripts; learn how in this how-to article by Scripting Guy Ed Wilson.   Microsoft Scripting Guy Ed Wilson here. Last Sunday, I spent the morning creating a Windows PowerShell ISE profile. Today, I thought I would add something to that profile that will make my ...

Copy CSV Columns to an Excel Spreadsheet by Using PowerShell

Summary: Join the Microsoft Scripting Guys as they show you how to copy CSV columns to a Microsoft Excel spreadsheet by using Windows PowerShell.   Hey, Scripting Guy! I love comma-separated value (CSV) files. To me, it seems as if that was the best way to store data. It is almost universally accepted and is still widely used. The ...

Copy Data from One Excel Spreadsheet to Another with PowerShell

Summary: The Microsoft Scripting Guys show you how to copy data from one Microsoft Excel spreadsheet to another one by using Windows PowerShell.   Hey, Scripting Guy! I have this monster Microsoft Excel spreadsheet that I need to make changes to. Frankly, it kind of scares me, because we use this spreadsheet for just about everything...