Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

How Can I Copy Selected Columns From a CSV File to an Excel File?

June 4, 2007 Jun 4, 2007 06/4/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file?-- MdP (image) (image) (image) Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time continuum. Some of you might be concerned that ...

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

How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?

May 1, 2007 May 1, 2007 05/1/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet?-- NN(image) (image) (image) Hey, NN. Please excuse any bloodstains that might appear on your screen; as it turns out, the Scripting Guy who writes this column was involved in an … incident … this past weekend. Ah, but...

How Can I Assign a Background Color to Cells in a Spreadsheet and Then “Sum” Those Cells?

April 27, 2007 Apr 27, 2007 04/27/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I assign a background color (based on a specified value) to a spreadsheet cell and then “sum” those cells?-- JC(image) (image) (image) Hey, JC. Thanks for the question. And yes, you heard correctly: in his last game the Scripting Son did indeed go 4-for-4, banging out three singles and a double. That...