Scripting Blog [archived]

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

Excel spreadsheet - Scripting Blog [archived]

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

How Can I Copy a File Numerous Times and Rename Each of Them from a List in Excel?

June 27, 2006 Jun 27, 2006 06/27/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy a file 150 times and then rename each of those copies using a list of names found in an Excel spreadsheet?-- DF(image) (image) (image) Hey, DF. You know, when we first started this column 2 years ago (must be time to mention the 500th Hey, Scripting Guy! celebration again) our biggest concern was ...

How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?

May 25, 2006 May 25, 2006 05/25/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I change all the lowercase letters in an Excel worksheet to uppercase letters?-- BC(image) (image) (image) Hey, BC. Have you ever heard the old expression, “If you want something done you have to do it yourself”? Well, to tell you the truth, we Scripting Guys had heard of that old expression, but we ...

How Can I Create a New Excel Spreadsheet at Midnight Each Night?

May 18, 2006 May 18, 2006 05/18/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I create a new Excel spreadsheet at midnight each night? I’d like each spreadsheet to have a file name similar to this: 6-1-06.xls.-- DH(image) (image) (image) Hey, DH. You know, often-times the simplest approach is also the best approach. For example, the other night the Scripting Son was having a ...

How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?

April 6, 2006 Apr 6, 2006 04/6/06
ScriptingGuy1
(image) Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer?-- BB(image) (image) (image) Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting Guys have at the moment is some code for ...