Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?

January 29, 2008 Jan 29, 2008 01/29/08
ScriptingGuy1
(image) Hey, Scripting Guy! I need a script that can read all the values in a spreadsheet and then change the background colors of the cells in that spreadsheet based on a range of values. For example, if the value is less than 20 the cell gets colored one color; if the cell is between 20 and 40 it gets colored another color; and so on. How ...

Hey, Scripting Guy! How Can I Import Multiple Worksheets into an Access Database?

January 21, 2008 Jan 21, 2008 01/21/08
ScriptingGuy1
(image) Hey, Scripting Guy! I’m trying to import a spreadsheet into an Access database. The problem is that the spreadsheet has multiple worksheets. I can import the first worksheet without any problem, but I can’t figure out how to import all the other worksheets in the file. How can I import multiple worksheets into an Access ...

Hey, Scripting Guy! How Can I Search For Values in an Excel Worksheet?

January 18, 2008 Jan 18, 2008 01/18/08
ScriptingGuy1
(image) Hey, Scripting Guy! How can I use Excel’s Find method to search for values within a worksheet?-- SK(image) (image) (image) Hey, SK. Before we begin today, we have a question for you, and for everyone else out there in Scripting Land. Back when the Scripting Guys first started planning the 2008 Winter Scripting Games (February ...

Hey, Scripting Guy! How Can I Cut a Row From One Office Excel Spreadsheet and Paste That Row Into Another Spreadsheet?

December 5, 2007 Dec 5, 2007 12/5/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I cut a row from an Office Excel spreadsheet and paste it into the first unused row in another Excel spreadsheet?-- NC(image) (image) (image) Hey, NC. We apologize if today’s column feels a little damp; as it turns out, those of us in the Seattle area are experiencing another one of the Puget Sound’s...

Hey, Scripting Guy! How Can I Determine the Value of the Last Cell in an Office Excel Range?

November 2, 2007 Nov 2, 2007 11/2/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I determine the value of the last cell in a range like C1:C10?-- MJdR(image) (image) (image) Hey, MJdR. You know, just a few days ago word leaked that a Federal Emergency Management Agency (FEMA) press conference held to discuss the US government’s response to the recent spate of wildfires in ...