Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?

February 20, 2007 Feb 20, 2007 02/20/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I specify the number of decimal places to be displayed in an Excel spreadsheet?-- JS(image) (image) (image) Hey, JS. Yes, it is Presidents Day here in the US, a day on which schools, banks, and government offices are all closed. Fortunately, though, the Scripting Guys are open and ready for business. Why...

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

February 13, 2007 Feb 13, 2007 02/13/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I configure Office Excel to autosave every 5 minutes?-- KK (image) (image) (image) 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 ...

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

February 9, 2007 Feb 9, 2007 02/9/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I save an Office Excel chart as a picture?-- JB (image) (image) (image) 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 ...

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
(image) 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 (image) (image) (image) Hey, EP. You know, before the Scripting Guy who writes this column started writing this column, he vowed that Hey, Scripting Guy...

Hey, Scripting Guy! How Can I Convert an Office Excel Spreadsheet to XML?

January 26, 2007 Jan 26, 2007 01/26/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I convert an Office Excel spreadsheet to XML?-- KE (image) (image) (image) Hey, KE. We apologize in advance if today’s column seems a little rushed; at the moment, we’re sitting in an office, surrounded by boxes and packing crates and waiting for the movers to come in and clear everything out...