Scripting Blog [archived]

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

How Can I Use Windows PowerShell to Automate Microsoft Excel?

(image) Hey, Scripting Guy! How can I use Windows PowerShell to automate Microsoft Excel?-- MW(image) (image) (image) Hey, MW. Yes, it’s true: the week of November 6-10, 2006 will be Windows PowerShell Week on TechNet, with the Scripting Guys presenting a series of webcasts (one each day, Monday through Friday) designed to introduce you ...

How Can I Get a Total Page Count for All the Word Documents in a Folder?

(image) Hey, Scripting Guy! How can I get a total page count for all the Word documents in a folder?-- RA(image) (image) (image) Hey, RA. You’ll have to forgive the Scripting Guy who writes this column if he seems a little tired this morning. Yesterday was the first day of school in the Lake Washington School District and, as you might ...

How Can I Alternate Row Colors in an HTA?

(image) Hey, Scripting Guy! How can I alternate row colors (using the green/white style) in an HTA?-- MK(image) (image) (image) Hey, MK. You know, we almost didn’t answer you question. Not because it wasn’t a good question, but simply because – like all the questions we get – we received this one in email. Based on what happened ...

How Can I Tell Which Numbers Are Missing From a Sequence of Numbers Found in a Text File?

(image) Hey, Scripting Guy! How can I look at a sequence of numbers in a text file and identify which numbers are missing from the sequence?-- TP(image) (image) (image) Hey, TP. Don’t you know that it’s Friday? This sounds like a tricky question to answer, and the Scripting Guys have an agreement with Microsoft that we don’t have to ...