Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Separate The Month From the Year in a Date String Like 122007?

April 3, 2008 Apr 3, 2008 04/3/08
ScriptingGuy1
(image) Hey, Scripting Guy! I have a column of data in Microsoft Excel that is formatted as MYYYY (12008 = January 2008) and MMYYYY (122007 = December 2007). I need to split these values into month and year, but I can’t figure out how to do that. Any suggestions?-- DW(image) (image) (image) Hey, DW. Well, it’s finally beginning to warm...

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

Hey, Scripting Guy! How Can I Read Custom Summary Information Properties for an Office Excel File?

February 7, 2008 Feb 7, 2008 02/7/08
ScriptingGuy1
(image) Hey, Scripting Guy! We’ve added a number of custom properties to the summary information pages of our Office Excel files. How can I access those custom properties using a script?-- UR(image) (image) (image) Hey, UR. You know, the Scripting Guy who writes this column almost didn’t write this column today. That’s because he’s...