The Admin’s First Steps: Capacity Planning Part 3

Summary: Richard Siddaway talks about using Windows PowerShell to create capacity planning reports.  Hey, Scripting Guy! I’ve just starting learning Windows PowerShell, and I understand how to use it as a scripting language and shell. I’ve been told to start performing capacity planning for my servers and was wondering how I can use PowerShell to…


Use PowerShell to Work with Pictures in Microsoft Excel

Summary: Guest Blogger Robert Robelo shows how to use Windows PowerShell to work with images in Microsoft Excel.   Microsoft Scripting Guy Ed Wilson here. Our guest blogger today is Robert Robelo. First, I want to give Robert a chance to tell us a little bit about himself. I live in Nicaragua. I have been…


Use a PowerShell Module to Easily Export Excel Data to CSV

Summary: Learn how to use a Windows PowerShell module to easily import and export Excel data.   Microsoft Scripting Guy Ed Wilson here. Jeremy Engel has joined us today to talk about using a Windows PowerShell module to easily import and export Excel data. Take it away, Jeremy!   I started coding at the age…


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…

15

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…

12

Use PowerShell to Remove Personal Information from Excel

Summary: Learn how to use Windows PowerShell to remove personal and other information from Microsoft Excel workbooks in this Scripting Guys article.   Hey, Scripting Guy! At times, I really hate where I work. It seems everyone is always scared. They are scared to say what they really think in meetings, they are scared to…

6

Save a Microsoft Excel Workbook as a PDF File by Using PowerShell

Summary: Microsoft Scripting Guys show you how to use Windows PowerShell to save a Microsoft Excel workbook as a PDF file.    Hey, Scripting Guy! There are some things I really enjoy about working for a small company. I am the only IT person, and as a result I get a chance to do everything….

7

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (1/22/10)

In this post: How Can I Manage a Remote Storage Array? How Can I Have a Dialog Box’s OK Button Clicked Automatically? How Can I Format Microsoft Excel Columns with Windows PowerShell? Troubleshooting a Script That Creates a Shortcut on a User’s Desktop How Can I Manage a Remote Storage Array? Hey, Scripting Guy! Here…

1