Scripting Blog [archived]

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

September 2006 - Page 2 of 4 - Scripting Blog [archived]

How Can I Verify That All the Items in a List Also Appear in Another List?

September 22, 2006 Sep 22, 2006 09/22/06
ScriptingGuy1
(image) Hey, Scripting Guy! I have a dumb question for you: If I have two lists how can I verify that all the items in list 2 can be found in list 1?-- SS(image) (image) (image) Hey, SS. Trust us; we’ve heard sillier questions. For example, awhile back the Scripting Son came downstairs on a Saturday morning to find the Scripting Dad ...

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 Verify That All the Characters in a String are Either A-to-Z (Uppercase Letters) or the Digits 0-through-9 in a HTA?

September 20, 2006 Sep 20, 2006 09/20/06
ScriptingGuy1
(image) Hey, Scripting Guy! In an HTA, how can I verify that all the characters are either A-to-Z (uppercase letters) or the digits 0-through-9?-- MB(image) (image) (image) Hey, MB. You want to talk irony? Oh. Well, we’re going to talk irony anyway. In yesterday’s column we tried to be cute, posing as the illegitimate children of a non...

How Can I Locate All the Folders That Have ArchiveASN in the Path?

September 19, 2006 Sep 19, 2006 09/19/06
ScriptingGuy1
(image) Hey, Scripting Guy! How can I locate all the folders on a computer that have \Archive\ASN\ somewhere in the path?-- AB(image) (image) (image) Hey, AB. We hope this message finds you well. Perhaps you are surprised to hear from us like this; a mutual friend provided us with your name and assured us that you were a responsible and ...

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