Showing results for Office - Scripting Blog [archived]

Hey, Scripting Guy! How can I set the print area in an Excel spreadsheet?-- PRP 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’s because he didn’t want to make any ...

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 Hey, ST. You know, sometimes it’s tough being a Scripting Guy. After a...

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 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 writes this column bemoaned the fact t...

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 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 mention it again anyway, because time really...

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 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, jolly old self these days.” Sadly, that’s true. A...