Scripting Blog [archived]

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

Microsoft Excel - Scripting Blog [archived]

How Can I Make the First Character in a Cell Uppercase and All the Other Characters Lowercase?

September 21, 2006 Sep 21, 2006 09/21/06
ScriptingGuy1
(image) Hey, Scripting Guy! In an Excel worksheet, how can I make the first character in each cell uppercase and the remaining letters in each cell lowercase?-- DW(image) (image) (image) Hey, DW. To begin with, we hope you had a happy holiday season; you didn’t eat too much turkey, did you? As for the Scripting Guys, we all – oh, sorry...

How Can I Copy a Worksheet to a New Spreadsheet?

September 18, 2006 Sep 18, 2006 09/18/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy a worksheet in an existing Excel spreadsheet to a new spreadsheet?-- TY(image) (image) (image) Hey, TY. Before we tackle your question we wanted to note that, as we write this, the University of Washington football team has a winning record. Sure, we’re only three weeks into the college football...

How Can I Use Windows PowerShell to Automate Microsoft Excel?

September 8, 2006 Sep 8, 2006 09/8/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I use Windows PowerShell to automate Microsoft Excel?-- MW(image) (image) (image) Hey, MW. Yes, it’s true: the week of November 6-10, 2006 will be Windows PowerShell Week on TechNet, with the Scripting Guys presenting a series of webcasts (one each day, Monday through Friday) designed to introduce you ...

How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?

July 20, 2006 Jul 20, 2006 07/20/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I tell if a specified worksheet exists in an Excel workbook?-- MVK(image) (image) (image) Hey, MVK. Back when he was in high school (that was about 3 or 4 years ago, of course), the Scripting Guy who writes this column was kind of half-watching a variety show on TV. The show featured a man and his dogs...