Scripting Blog

A place to learn about PowerShell and share stories of automation

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...

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. I work with the Exchange Server. I add ...

Hey, Scripting Guy! How Can I Search a Microsoft Excel Workbook for Links to Other Workbooks?

    Hey, Scripting Guy! I have a user in our finance department that asked me today about using a Windows PowerShell script to identify Microsoft Excel workbooks that have links inside them to other Microsoft Excel workbooks. Frankly, I am not exactly sure what she is talking about, but I do think it is great that she asked me about...

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? Hey, Scripting Guy! Here is my situation. I started a new job recently, and I am working in the Storage and Virtualization group. Windows PowerShell + PowerCLI do a great job for the VM side of things. Now on the storage things, we are using Equallogic, which does not have...