Hey, Scripting Guy! I have a script that compares two email addresses and tells me whether or not they are the same. Sometimes the email addresses are the same, but the case is different: for example, one address might be example@abc.com and the other...

Hey, Scripting Guy! We have a custom application that adds some attributes to the Active Directory schema. These attributes have hyphens in their names, and I can’t figure out how to retrieve the value of those attributes; any time I try to connect...

Hey, Scripting Guy! How can I check to see if a particular file exists and, if it does, exit the script? -- TO Hey, TO. There are at least two ways to check for the existence of a file (that’s the real key here; exiting the script is easy). One of...

Hey, Scripting Guy! In previous columns you’ve shown us how to present users with a dialog box that enables them to select files. Is there any way to show them a dialog box that only lets users select folders? -- LP Hey, LP. You know, you’ve come to...

Hey, Scripting Guy! How can I delete data from a spreadsheet yet keep all the formatting? -- TB Hey, TB. From your email it sounds like you have a script that periodically replaces data in a spreadsheet with new, up-to-date values. The spreadsheet...

Hey, Scripting Guy! In my logon script how can I determine the name of the domain controller that authenticated the user? -- CK Hey, CK. You know, one of the unwritten rules for being a Scripting Guy is that you should never do anything hard more than...

Hey, Scripting Guy! How can I determine the local area connection that’s associated with a particular IP address? -- SH Hey, SH. Believe it or not, this is a fairly complicated procedure, and for two reasons. To begin with, we have to use two separate...

Hey, Scripting Guy! How can I change the amount of disk space set aside for Internet Explorer’s temporary files folder? -- AD Hey, AD. The first draft of this column we were able to bang out in no time; after all, it consisted entirely of this: ...

Hey, Scripting Guy! I know I can use the Split function to split a line into individual items. But how can I tell how many “splits” I ended up with; that is, how many individual items did I generate from a single line? -- SA Hey, SA. For those of you...

Hey, Scripting Guy! How can I clear a text box in an HTA? -- CB Hey, CB. You know, it’s been awhile since we’ve answered a question about HTAs (HTML Applications). And we could probably get away with that except for the fact that a month or so ago...

Hey, Scripting Guy! How can I hide a specific toolbar in Microsoft Word? -- AG Hey, AG. Now this question brings back memories. When our editor joined the team one of her first actions was to make us redo a whole bunch of screenshots we had made for...

Hey, Scripting Guy! How can I tally items in a text file? -- JA Hey, JA. If we understand you correctly you have a text file that consists of a number of lines, each line representing a particular item. Just to keep things simple, let’s say your text...

Hey, Scripting Guy! How can I list all the user profiles on a computer? -- GN Hey, GN. You want to know a secret? We hate questions about user profiles. It’s not that we have anything against user profiles. The problem is that user profiles represent...

Hey, Scripting Guy! How can I list all the user profiles on a computer? -- GN Hey, GN. You want to know a secret? We hate questions about user profiles. It’s not that we have anything against user profiles. The problem is that user profiles represent...

Hey, Scripting Guy! I need to create a custom alert box that has over 1,000 characters in it. The message box used by Wscript.Echo can hold all the characters, but I can’t change the message box title. I can change the title of a message box used by the...

Hey, Scripting Guy! How can I retrieve the path to the %windir% folder on a computer? -- DS Hey, DS. Interesting that you should ask this question. This same question happened to be asked on an internal Microsoft mailing list just the other day, and...

Hey, Scripting Guy! How can I open an Excel workbook and retrieve the names of all the worksheets? -- JG Hey, JG. It’s the first day back after a three-day weekend, and this morning all the Scripting Guys stumbled into the office and just stared blankly...

Hey, Scripting Guy! How can I change the Copy music to this location folder in Windows Media Player? -- BD Hey, BD. You know, a lot of people think that the reason we Scripting Guys don’t do very much work is because we’re just plain lazy. Those people...

Hey, Scripting Guy! I’m using the Win32_ComputerSystem class to get the name of the logged-on user. The name comes back formatted like this: Domain\Name . How can I extract just the user name? -- KW Hey, KW. As our much-beloved and highly-respected...

Hey, Scripting Guy! How can I save (to a separate file) all the paragraphs in a Word document that are formatted using a particular style, like Heading 1? -- RN Hey, RN. You know, when we first read this question we thought, “Interesting. But why would...

Hey, Scripting Guy! How can I use ADO to open a text file that has spaces in the file name? -- TL Hey, TL. You might not even remember sending us this question; to say it’s been awhile would be an understatement. (You should have seen all the dust...

Hey, Scripting Guy! How can I correlate logical drives and physical disks? -- LB Hey, LB. We’ll make a deal with you: we’ll show you a script that can tell you which logical drives are found on which physical disks, and you promise not to say, “Wait...

Hey, Scripting Guy! How can I remove the last carriage return-linefeed in a text file? -- LEK Hey, LEK. From the rest of your email you note that you’re using the FileSystemObject to read a text file, then using the contents of that text file as a...

Hey, Scripting Guy! At work we need to use a proxy server to connect to the Internet; when I take my laptop home to work, however, I don’t need to use a proxy server. I know I can use the Internet Options in Control Panel to change between using a proxy...

Hey, Scripting Guy! Our auditors have suggested that we randomly pick projects to examine and ensure that each project was completed and signed off per company policy. Because these projects are numbered sequentially I thought maybe we could write a script...