Scripting Blog

A place to learn about PowerShell and share stories of automation

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

Hey, Scripting Guy! How can I configure an Active Directory user account so that the account password never expires?-- BB 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 Scripting Son was recently asked to ...

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

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 Hey, SF. Oh, and welcome to Hey, Scripting Guy!, your daily source for scripting information. We’d like you to know ...

How Can I Delete Duplicate Items From an Array?

Hey, Scripting Guy! How can I delete duplicate items from an array?-- WR 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 possibly be one of our products.) ...

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

Hey, Scripting Guy! How can I center-align a picture in a Word document?-- CD 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 used in the writing of today’...

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

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. How can I...

Feedback usabilla icon