Showing archive results for 2006

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 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-existent defense minister and trying to ...

Hey, Scripting Guy! How can I locate all the folders on a computer that have \Archive\ASN\ somewhere in the path?-- AB 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 trustworthy person. Recently we Script...

Hey, Scripting Guy! How can I copy a worksheet in an existing Excel spreadsheet to a new spreadsheet?-- TY 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 season, and the UW’s record is only 2-...

Hey, Scripting Guy! How can I determine if I have any Internet Explorer windows open to a particular Web site?-- N Hey, N. Before we begin the Scripting Guys would like to state, for the record, that we have never tried to obtain each other’s phone records nor have we ever even considered listening in on each other’s phone conversations. This ha...

Hey, Scripting Guy! How can I get a list of all the databases on a SQL Server computer?-- ER Hey, ER. Before we answer your question, we’d like to take a moment to offer our opinions on all the major – and controversial – issues of the day. We can do that because the Scripting Editor is on vacation and, well, you know what they say: when the cat...