Scripting Blog [archived]

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

May 2007 - Scripting Blog [archived]

How Can I Wait Until One Application Has Quit Before Starting a Second Application?

May 31, 2007 May 31, 2007 05/31/07
ScriptingGuy1
(image) Hey, Scripting Guy! I have a script that starts two applications; however, the second application can not start until the first program has finished running. How can I ensure that my second program doesn’t start until the first one ends?-- OR (image) (image) (image) Hey, OR. Not too long ago the Scripting Guy who writes this ...

How Can I Delete the First Line and the Last Line in a Text File?

May 30, 2007 May 30, 2007 05/30/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I delete the first line and the last line in a text file?-- TF (image) (image) (image) Hey, TF. We don’t know if anyone has ever noticed, but Hey, Scripting Guy! tends to meander from time-to-time; there are those occasions when it seemingly takes forever for us to get around to answering the question ...

How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?

May 29, 2007 May 29, 2007 05/29/07
ScriptingGuy1
(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row?-- GL (image) (image) (image) Hey, GL. Some of you might have noticed that there was no Hey, Scripting Guy! column yesterday. Is that because the Scripting Guys are slacking off and shirking their...

How Can I Export an HTA Table to Excel?

May 25, 2007 May 25, 2007 05/25/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I put a button in an HTA that, when clicked, exports an HTML table to Excel?-- DW (image) (image) (image) Hey, DW. You know, yesterday afternoon the Scripting Guy who writes this column went to get his hair cut, figuring he needs to look his best for TechEd 2007. (It was only after he got his hair cut ...