Scripting Blog [archived]

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

June 2007 - Page 2 of 5 - Scripting Blog [archived]

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 Open a Window to a UNC Location?

June 22, 2007 Jun 22, 2007 06/22/07
ScriptingGuy1
(image) 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 (image) (image) (image) Hey, CY. You know, during the heyday of the Cold War the U.S. had analysts whose sole duty ...

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, ...

How Can I Insert Commas at Specified Locations in Each Line in a Text File?

June 20, 2007 Jun 20, 2007 06/20/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I insert commas at specified locations in each line in a text file?-- MM (image) (image) (image) 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 ...

How Can I Remove a Specific Set of Users From the Local Administrators Group?

June 19, 2007 Jun 19, 2007 06/19/07
ScriptingGuy1
(image) 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 (image) (image) (image) 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 ...