A place to learn about PowerShell and share stories of automation
September 29, 2006Sep 29, 200609/29/06Hey, Scripting Guy! How can I determine whether Terminal Services is enabled on a Windows Server 2003 computer?— DD
Hey, DD. You know, it turns out to be true: good things will come to those who wait. According to the front page of The Seattle Times,
September 28, 2006Sep 28, 200609/28/06Hey, Scripting Guy! I have a file which includes a number of file names. All of these names consist of a series of numbers followed by a .zip file extension; for example, 1234.zip, 5678.zip, etc. How can I write a script that locates all these file names and then saves just the names to a second file?—
September 27, 2006Sep 27, 200609/27/06Hey, Scripting Guy! We have an Excel spreadsheet that tracks the status of all our projects. In that spreadsheet the status for a project is indicated by a color assigned to a cell. How can I use a script to determine the color of these cells?—
September 26, 2006Sep 26, 200609/26/06Hey, Scripting Guy! How can I run a Windows PowerShell script from the Run dialog box or from a shortcut? In the Run dialog box I type something like c:\scripts\test.ps1 but my script just opens up in Notepad.— RS
Hey, RS.
September 25, 2006Sep 25, 200609/25/06Hey, Scripting Guy! How can I insert text into an existing Microsoft Word bookmark?— WM
Hey, WM. Believe it or not, this turned out to be the most difficult script the Scripting Guy who writes this column has ever had to create.
September 22, 2006Sep 22, 200609/22/06Hey, Scripting Guy! I have a dumb question for you: If I have two lists how can I verify that all the items in list 2 can be found in list 1?— SS
Hey, SS. Trust us; we’ve heard sillier questions.
September 21, 2006Sep 21, 200609/21/06Hey, Scripting Guy! In an Excel worksheet, how can I make the first character in each cell uppercase and the remaining letters in each cell lowercase?— DW
Hey, DW. To begin with, we hope you had a happy holiday season; you didn’t eat too much turkey,
September 20, 2006Sep 20, 200609/20/06Hey, Scripting Guy! In an HTA, how can I verify that all the characters are either A-to-Z (uppercase letters) or the digits 0-through-9?— MB
Hey, MB. You want to talk irony?
Oh. Well, we’re going to talk irony anyway. In yesterday’s column we tried to be cute,
September 19, 2006Sep 19, 200609/19/06Hey, Scripting Guy! How can I locate all the folders on a computer that have \Archive\ASN\ somewhere in the path?— AB
Hey, AB. We hope this message finds you well. Perhaps you are surprised to hear from us like this; a mutual friend provided us with your name and assured us that you were a responsible and trustworthy person.
September 18, 2006Sep 18, 200609/18/06Hey, Scripting Guy! How can I copy a worksheet in an existing Excel spreadsheet to a new spreadsheet?— TY
Hey, TY. Before we tackle your question we wanted to note that, as we write this, the University of Washington football team has a winning record.
