Scripting Blog

A place to learn about PowerShell and share stories of automation

Hey, Scripting Guy! How Can I Open and Close Outlook Attachments?

Hey, Scripting Guy! We recently implemented a scheme whereby Team Leads or Contract Sponsors may request server access for their Team members by submitting an Excel spreadsheet. To this end, I proposed a script that will open Outlook, look for items in the Inbox that contain a particular Subject line (we will pick the wording later) and, for ...

Hey, Scripting Guy! How Can I Change the Letter Case of My File Names?

Hey, Scripting Guy (and the $12 million-a-year Scripting Editor)! Is there a way to mass-rename all the files in a folder, changing the letter case as needed?-- MV Hey, MV. To begin with, we should mention that we know that you actually asked two questions in your email. We’re going to deal with the first question – mass-renaming...

Hey, Scripting Guy! How Can I Modify a Text File Based on the Value of a Particular Column in the File?

Hey, Scripting Guy! I need some help in cleaning up a text file. I have a file that contains multiple columns of data, and I need to either delete or modify lines in the file based on the value of the 13th column. Can you help me?-- AM Hey, AM. You know, usually we start off this column with some amusing (well, OK, semi-amusing) anecdote or ...

Hey, Scripting Guy! How Can I Use a File Mask When Renaming Files?

Hey, Scripting Guy! How can I change file names using a file mask? You know, like when you run the command-line command ren ??x???p?.* ?a????bc.x??.-- AM Hey, AM. Well, the big news out of Seattle is that the Mariners have fired their general manager, Bill Bavasi; that’s to be expected when you spend $117 million on salaries and the ...

Hey, Scripting Guy! How Can I Remove the Speaker Notes From a PowerPoint Presentation?

Hey, Scripting Guy! We have a whole bunch of PowerPoint presentations that we would like to share with other people. However, before we make these presentations available we’d like to remove all the speaker notes from each one. Is there a way we can use a script to remove the speaker notes from a PowerPoint presentation?-- TW Hey, TW. ...

Feedback usabilla icon