# Scripting Blog [archived]

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

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

(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?

(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?

(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?

(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?

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