Scripting Blog [archived]

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

How Can I Determine Whether Terminal Services is Enabled on a Windows Server 2003 Computer?

(image) Hey, Scripting Guy! How can I determine whether Terminal Services is enabled on a Windows Server 2003 computer?-- DD(image) (image) (image) 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, people who are grouchy and cantankerous today are more ...

How Can I Locate Strings That Consist of a Series of Numbers Followed by .ZIP?

(image) Hey, 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?-- RS(image) (image) (image) ...

How Can I Determine the Background Color of a Spreadsheet Cell?

(image) Hey, 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?-- AE(image) (image) (image) Hey, AE. Just a second; we need to catch our breath. Sorry. ...

How Can I Run a Windows PowerShell Script from the Run Dialog Box or a Shortcut?

(image) Hey, 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(image) (image) (image) Hey, RS. We have just one thing to say: University of Washington 29, UCLA 19. And this after ...

How Can I Insert Text Into an Existing Microsoft Word Bookmark?

(image) Hey, Scripting Guy! How can I insert text into an existing Microsoft Word bookmark?-- WM(image) (image) (image) 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. Not because the script itself is very hard; as you’re about to see, it’s not...