Scripting Blog [archived]

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

How Can I Remove Any Line in a Text File That Contains a Specified String Value?

(image) Hey, Scripting Guy! How can I remove any line in a text file that contains the string f0?-- CJ(image) (image) (image) Hey, CJ. Before we begin, we have a question for you: are you by any chance a serious player of online video games like EverQuest or World of Warcraft? Admittedly, none of the Scripting Guys play these games; we ...

How Can I Backup an Event Log to a Text File?

(image) Hey, Scripting Guy! How can I backup an event log to a text file?-- IMBDS(image) (image) (image) Hey, IMBDS. You know, the Scripting Guys have dedicated their lives to helping others. (Well, OK, originally we dedicated our lives to having others help us. But when no one seemed very interested in that we changed our minds.) That ...

How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?

(image) Hey, Scripting Guy! How can I get a list of all the email addresses in my Sent Items and then write those addresses to an Excel spreadsheet?-- RD(image) (image) (image) Hey, RD. As a matter of fact, yes, we are having problems focusing on work today. Granted, that’s true most days. However, at least today it’s understandable, ...

How Can I Add a Background Picture to an Excel Worksheet?

(image) Hey, Scripting Guy! How can I add a background picture to an Excel worksheet?-- GA(image) (image) (image) Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt … right before he eats his daily doughnut. (But don’t worry: it’s a medically-...

How Can I Remove All the Non-Alphabetic Characters in a String?

(image) Hey, Scripting Guy! How can I remove all the non-alphabetic characters in a string?-- CD(image) (image) (image) Hey, CD. You know, typically the Scripting Guys don’t play favorites; we treat all our readers and all the questions we receive exactly the same. (OK, so, technically that means that, for the most part, we simply ignore...