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! How can I open a window to a UNC location? You've given many examples that involve opening a web page. I have been unable to get a similar result trying to get a script to open \\server\share.-- CY Hey, CY. You know, during the heyday of the Cold War the U.S. had analysts whose sole duty was to pore over photographs taken in...
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...
Hey, Scripting Guy! How can I insert commas at specified locations in each line in a text file?-- MM Hey, MM. Seeing as how Father’s Day has just come and gone we couldn’t talk about inserting commas into text files without first relating a heartwarming Father’s Day tale of our own. On Father’s Day the Scripting Guy who writes this column went ...
Hey, Scripting Guy! How can I delete all the users whose name starts with GER/ad_ from the local Administrators group on a computer?-- ID Hey, ID. It’s a Friday as the Scripting Guy who writes this column writes this column. Usually Fridays are a very sad day for this Scripting Guy: after all, when Friday comes to an end he faces two days of ha...
