Scripting Blog [archived]

Hey, Scripting Guy! How Can I Summarize Information Found in a Spreadsheet Row?

July 2, 2008 Jul 2, 2008 07/2/08

ScriptingGuy1

(image) Hey, Scripting Guy! I have an Excel spreadsheet that tracks daily time for our employees, indicating whether the employee worked on a given day or took some type of leave (paid leave, leave without pay, sick leave, etc.). Is there a way to output a report showing the various leave types taken by each employee, along with the dates ...

Hey, Scripting Guy! How Can I Sort a Spreadsheet By Cell Color?

March 13, 2008 Mar 13, 2008 03/13/08

ScriptingGuy1

(image) Hey, Scripting Guy! We have an Excel spreadsheet in which we use different colors as a way to track status information. That works out really good for us, except for one thing: sometimes we’d like to sort the spreadsheet by color. As near as I can tell, however, Excel doesn’t let you sort a worksheet by color. Could a script help...

Hey, Scripting Guy! How Can I Check the Value of a Specific Cell in a Bunch of Office Excel Spreadsheets?

February 26, 2008 Feb 26, 2008 02/26/08

ScriptingGuy1

(image) Hey, Scripting Guy! How can I create a script that will list all the files in a directory that have a specific value in a specific cell of an Office Excel workbook? And can that be expanded into a find/replace function?-- RDC (image) (image) (image) Hey, RDC. Now that we’re finally beginning to get a bunch of scores posted for ...

Hey, Scripting Guy! How Can I Mark the First Occurrence of a Number in an Office Excel Spreadsheet?

February 20, 2008 Feb 20, 2008 02/20/08

ScriptingGuy1

(image) Hey, Scripting Guy! I’m trying to determine – and mark – the first occurrence of a number in an Office Excel worksheet. However, I can’t figure out how to go about doing this. Can you help?-- BH (image) (image) (image) Hey, BH. Before we launch into today’s column we have an announcement to make: the ...