Scripting Blog [archived]

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

How Can I Configure an Active Directory Account So the Password Never Expires?

(image) Hey, Scripting Guy! How can I configure an Active Directory user account so that the account password never expires?-- BB(image) (image) (image) Hey, BB. Before we start we have a question for you: wouldn’t you agree that Catch-22 is one of the four greatest novels ever written? We ask that because, in his English class, the ...

How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?

(image) Hey, Scripting Guy! How can I rename a bunch of folders using a script? The old folder names are in the first column of an Excel spreadsheet and the new folder names are in the second column of an Excel spreadsheet.-- SF(image) (image) (image) Hey, SF. Oh, and welcome to Hey, Scripting Guy!, your daily source for scripting ...

How Can I Delete Duplicate Items From an Array?

(image) Hey, Scripting Guy! How can I delete duplicate items from an array?-- WR(image) (image) (image) Hey, WR. You know, if Microsoft has a weakness – and we’re not saying that it does, we’re just saying if it does – it’s this: we never make mistakes. (What’s that? What about Windows ME? That’s a weird name; couldn’t ...

How Can I Center-Align a Picture in a Word Document?

(image) Hey, Scripting Guy! How can I center-align a picture in a Word document?-- CD(image) (image) (image) Hey, CD. In light of the controversy surrounding World Series game 2 (was Detroit Tigers pitcher Kenny Rogers throwing “goopballs” or wasn’t he?) the Scripting Guys felt it was important to note that no illegal substances were...

How Can I Repeatedly Prompt a User to Enter a File Name?

(image) Hey, Scripting Guy! I have approximately 100 Excel files (all with names like 9365.xls) in a folder. I’d like to prompt a user for a file name, open the file, retrieve information from a specified cell, then close the file (ideally Excel would never appear on screen). I’d then like to prompt the user to enter another file name. ...