A place to learn about PowerShell and share stories of automation
October 31, 2006Oct 31, 200610/31/06Hey, 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?
October 30, 2006Oct 30, 200610/30/06Hey, 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.—
October 27, 2006Oct 27, 200610/27/06Hey, 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.
October 26, 2006Oct 26, 200610/26/06Hey, 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’s Hey,
October 25, 2006Oct 25, 200610/25/06Hey, 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).
October 24, 2006Oct 24, 200610/24/06Hey, Scripting Guy! Over the past year or so you’ve answered several questions in which you use a script to connect to the Inbox in Microsoft Outlook. But how can I connect to the Junk Mail folder in Outlook?— ME
Hey,
October 23, 2006Oct 23, 200610/23/06Hey, Scripting Guy! How can I use Windows PowerShell to locate and delete all the .tmp files on a drive?— OR
Hey, OR. You know, there’s an old saying: Give a man a fish and he’ll eat for a day; teach that man to fish and he’ll eat for the rest of his life.
October 20, 2006Oct 20, 200610/20/06
Hey, Scripting Guy! How can I print a Microsoft Access report?— RW
Hey, RW. You know the cool thing about being a Scripting Guy – aside from the opportunity to pal around with Paris and Nicole – is the fact that people think we know what we’re doing.
October 19, 2006Oct 19, 200610/19/06Hey, Scripting Guy! How can I tell whether a number is even or odd?— JO
Hey, JO. You know, just this morning the Scripting Guy who writes this column was driving in to work when he heard an advertisement for a store that sells HD TVs.
October 18, 2006Oct 18, 200610/18/06Hey, Scripting Guy! I have a series of string values that I need to convert to an array, splitting the value on the ampersand (&). However, if the ampersand is followed by amp (in other words, if the string is &) I don’t want to split the string at that point.
