Scripting Blog [archived]

Copy Data from One Excel Spreadsheet to Another with PowerShell

September 8, 2010 Sep 8, 2010 09/8/10

ScriptingGuy1

Summary: The Microsoft Scripting Guys show you how to copy data from one Microsoft Excel spreadsheet to another one by using Windows PowerShell.   (image) 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 ...

Use PowerShell to Remove Personal Information from Excel

September 7, 2010 Sep 7, 2010 09/7/10

ScriptingGuy1

Summary: Learn how to use Windows PowerShell to remove personal and other information from Microsoft Excel workbooks in this Scripting Guys article.   (image) 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 make ...

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

September 6, 2010 Sep 6, 2010 09/6/10

ScriptingGuy1

Summary: Microsoft Scripting Guys show you how to use Windows PowerShell to save a Microsoft Excel workbook as a PDF file.   (image)  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 ...

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

April 5, 2010 Apr 5, 2010 04/5/10

ScriptingGuy1

(image)     (image) 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 ...