Hey, Scripting Guy! How can I use Windows PowerShell to automate Microsoft Excel?-- MW 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 to Windows PowerShell. Those are
Hey, Scripting Guy! How can I get a total page count for all the Word documents in a folder?-- RA 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 expect, the scene in the Scriptin
Hey, Scripting Guy! How can I alternate row colors (using the green/white style) in an HTA?-- MK 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 recently at Radio Shack, the Scrip
Hey, Scripting Guy! How can I run a PowerPoint slide show from a script?-- IB Hey, IB. Talk about vindication! A couple years ago, when the Scripting Guy who writes this column first started messing around with Microsoft Office, he wrote a simple little script that could run a PowerPoint slide show. The other Scripting Guys laughed at him.
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 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 think very hard on Fridays. OK,