Scripting Blog

A place to learn about PowerShell and share stories of automation

Excel.Application - Scripting Blog

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
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 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 responsibilities? Of course; ...

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
Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet?-- NN 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 dedicated Microsoft employee ...

Hey, Scripting Guy! How Can I Configure Office Excel to Autosave Every 5 Minutes?

February 13, 2007 Feb 13, 2007 02/13/07
ScriptingGuy1
Hey, Scripting Guy! How can I configure Office Excel to autosave every 5 minutes?-- KK Hey, KK. You know, that’s a good question. As it turns out, the autosave capability in Microsoft Excel – hey, wait a minute: do you realize what day it is? Today is the first day of the 2007 Winter Scripting Games; why in the world are you ...

Hey, Scripting Guy! How Can I Save an Office Excel Chart as a Picture?

February 9, 2007 Feb 9, 2007 02/9/07
ScriptingGuy1
Hey, Scripting Guy! How can I save an Office Excel chart as a picture?-- JB Hey, JB. You know, yesterday was a good day for the Scripting Guy who writes this column. If the phone rings at the Scripting House and if it’s for the Scripting Guy who writes this column, well, it’s never really for the Scripting Guy who writes this ...

Hey, Scripting Guy! How Can I Change the Font Color in Office Excel If a Specified Condition is Met?

February 1, 2007 Feb 1, 2007 02/1/07
ScriptingGuy1
Hey, Scripting Guy! In an Office Excel spreadsheet, how can I change the color of the text if the value in column B minus the value in column A is greater than or equal to 10?-- EP Hey, EP. You know, before the Scripting Guy who writes this column started writing this column, he vowed that Hey, Scripting Guy! would have a laser-like focus ...