Scripting Blog [archived]

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

Hey, Scripting Guy! How Can I Copy a File to a Removable Drive If I Don’t Know the Drive Letter of That Drive?

(image) Hey, Scripting Guy! How can I determine if a computer has a removable drive attached to it and, if it does, copy a file to that drive? I have no way of knowing what the drive letter of that removable drive would be, assuming it even exists.-- SN(image) (image) (image) Hey, SN. You know, when you live in Seattle you don’t really ...

Hey, Scripting Guy! How Can I Find the Number (and Size) of All the Files Recently Modified or Added to a Computer?

(image) Hey, Scripting Guy! I'm looking for a script that can search a file server and list the number and total size of files that have been recently modified or added to the server. Any help would be appreciated!-- KT(image) (image) (image) Hey, KT. Before we launch into today’s column we thought we should tell you that the rumor is ...

Hey, Scripting Guy! How Can I Sort a Spreadsheet By Cell Color?

(image) Hey, Scripting Guy! We have an Excel spreadsheet in which we use different colors as a way to track status information. That works out really good for us, except for one thing: sometimes we’d like to sort the spreadsheet by color. As near as I can tell, however, Excel doesn’t let you sort a worksheet by color. Could a script help...

Hey, Scripting Guy! How Can I Use Windows PowerShell to Add a Domain User to a Local Group?

(image) Hey, Scripting Guy! I recently came across your article where you showed people how to use VBScript to add a domain user to a local group. How can I do that same task using Windows PowerShell?-- KE(image) (image) (image) Hey, KE. Before we begin we thought we should mention that the Scripting Guy who writes this column has a new ...

Hey, Scripting Guy! How Can I Return a List of All the Folders Whose Name Starts With a Specified String Value?

(image) Hey, Scripting Guy! How can I find all the folders that start with a specific string? For example, given the string 123 the script would find folders 123000 through 123999.-- MD(image) (image) (image) Hey, MD. Here in the US we’re still busy trying to figure out who’s going to run for President. (Figure out who will actually be...