Scripting Blog [archived]

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

How Can I Change the Background Color of a Cell Depending on the Date?

(image) Hey, Scripting Guy! I have a Microsoft Excel spreadsheet I periodically analyze using a script. How can I change the color of a cell to red if the date stored in that cell has passed?-- DM(image) (image) (image) Hey, DM. We were going to start today’s column off with some clever and witty remark about red-letter dates, but we ...

How Can I List All the Attributes Used by the Computer Class in Active Directory?

(image) Hey, Scripting Guy! How can I list all the attributes used by the Computer class in Active Directory?-- KP(image) (image) (image) Hey, KP. Thanks for your question. In response, yes, it is true that the Kirkland Fire, the Colt League baseball team coached by one of the Scripting Guys, won the city championship this past weekend, ...

How Can I Retrieve a List of OUs that have a Specific Word in Their Name?

(image) Hey, Scripting Guy! We have a number of OUs in our domain that have the word Servers in the OU name. How can I retrieve a list of those OUs?-- AM(image) (image) (image) Hey, AM. One of the Scripting Guys has a 15-year-old son who, whenever he hears his father tell a story about the good old days, rolls his eyes and says, “You’...

How Can I Get the Actual Text of a List Box or Dropdown List Option?

(image) Hey, Scripting Guy! In my HTA, how can I get the actual text of a list box or dropdown list option?-- MM(image) (image) (image) Hey, MM. You might be familiar with an old Mac Davis song, a song that starts off like this:Oh Lord it's hard to be humble When you're perfect in every way Now, admittedly, the Scripting Guys aren’t ...