The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Scripting Blog [archived]

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

How Can I Set the Print Area in an Excel Spreadsheet?

July 7, 2007 Jul 7, 2007 07/7/07

ScriptingGuy1

(image) Hey, Scripting Guy! How can I set the print area in an Excel spreadsheet?-- PRP (image) (image) (image) Hey, PRP. You know, before the Scripting Guy who writes this column wrote his very first column he took a sacred vow: he vowed never to take a sacred vow, at least not when it came to writing the Hey, Scripting Guy! column. That...

How Can I Delete Unread Emails That Are More Than 6 Months Old?

June 30, 2007 Jun 30, 2007 06/30/07

ScriptingGuy1

(image) Hey, Scripting Guy! We have a lot of users who let unread email messages pile up in their Outlook Inboxes; after awhile, that causes their Inboxes to fill up. How can I write a script users could run that would delete any unread messages that are more than 6 months old?-- ST (image) (image) (image) Hey, ST. You know, sometimes it...

How Can I Search For Red Text in a Microsoft Word Document?

June 27, 2007 Jun 27, 2007 06/27/07

ScriptingGuy1

(image) Hey, Scripting Guy! I have a huge document that features occasional lines printed in red. How can I extract just the lines that are printed in red?-- GH (image) (image) (image) Hey, GH. To begin with, the Scripting Guy who writes this column would like to say just one thing: never mind. In yesterday’s column the Scripting Guy who...

How Can I Delete Specified Rows in an Excel Spreadsheet?

June 23, 2007 Jun 23, 2007 06/23/07

ScriptingGuy1

(image) Hey, Scripting Guy! How can I delete a row in an Excel spreadsheet if there is a specific value in column A of that row?-- OI (image) (image) (image) Hey, OI. Before we get rolling on today’s column, have we mentioned that time is beginning to run out on the Scripting Guys TechEd Challenge? We have? Oh. Well, we’re going to ...

How Can I Color Every Other Row in an Excel Spreadsheet?

June 21, 2007 Jun 21, 2007 06/21/07

ScriptingGuy1

(image) Hey, Scripting Guy! When I create a new Excel spreadsheet, I’d like to color every other row in that spreadsheet. How can I do that?-- TM (image) (image) (image) Hey, TM. We know a lot of you have been wondering, “Gee, what’s the matter with the Scripting Guy who writes that column? He just doesn’t seem like his usual, ...

Scripting Blog [archived]

Office - Scripting Blog [archived]