Scripting Blog [archived]

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

Excel spreadsheet - Scripting Blog [archived]

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

How Can I Remove the Password When Opening an Excel Spreadsheet?

April 12, 2007 Apr 12, 2007 04/12/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I remove the password when opening an Excel spreadsheet?-- JE(image) (image) (image) Hey, JE. You know, it’s finally happened: after two-and-a-half years of writing this column we’ve finally run out of things to talk about. The “heartbeat sensor” that can tell you whether someone is hiding in the...

How Can I Import an Excel Spreadsheet Into an Access Database?

April 4, 2007 Apr 4, 2007 04/4/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I import an Excel spreadsheet into an Access database?-- IE(image) (image) (image) Hey, IE. Wait! Don’t tell us; let us guess. Just a moment … we’re picking up the vibrations now … the sensation is getting stronger and more distinct … OK, got it: you’d like to know how to import an Excel ...

How Can I Save a Table in an Access Database as a Spreadsheet?

April 3, 2007 Apr 3, 2007 04/3/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I save a table in an Access database as an Excel spreadsheet?-- OT(image) (image) (image) Hey, OT. You know, we appreciate the question, but where were you last week, when we really needed you? The truth is, last week was excruciatingly dull, at least for two of the Scripting Guys. While Scripting Guy ...