Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

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

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

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

(image) 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 (image) (image) (image) Hey, AM. You know, usually we start off this column with some amusing (well...

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

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

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

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