Scripting Blog [archived]

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

How Can I Locate All the Instances of a Particular File on a Computer?

(image) Hey, Scripting Guy! How can I locate all the instances of a particular file (like budget.xls) on a computer?-- MN(image) (image) (image) Hey, MN. Did you know that former heavyweight boxing champion George Foreman has 10 children, 5 sons and 5 daughters? Itโ€™s true. But thatโ€™s not the best part; the best part is that all 5 of ...

How Can I Bind to an Active Directory User Account Using Windows PowerShell?

(image) Hey, Scripting Guy! I’ve been playing around with Windows PowerShell, and I find it interesting. However, I have a problem. I’d like to use PowerShell as a quick way to get information about an Active Directory user account, but I can’t figure out how to bind to a user account. Any suggestions?-- BW (image) (image) (...

How Can I Get a List of the Unique Words Used in a Microsoft Word Document?

(image) Hey, Scripting Guy! How can I get a list of the unique words used in a Microsoft Word document?-- RK(image) (image) (image) Hey, RK. Funny you should mention unique words. Last Saturday the Scripting Coachโ€™s baseball team played in the city championship. Despite the importance of the game the team was missing two key players, and...

How Can I Copy a File Numerous Times and Rename Each of Them from a List in Excel?

(image) Hey, Scripting Guy! How can I copy a file 150 times and then rename each of those copies using a list of names found in an Excel spreadsheet?-- DF(image) (image) (image) Hey, DF. You know, when we first started this column 2 years ago (must be time to mention the 500th Hey, Scripting Guy! celebration again) our biggest concern was ...

How Can I Copy All the Comments From an Excel Worksheet to a Word Document?

(image) Hey, Scripting Guy! How can I copy all the comments from an Excel worksheet to a Word document?-- ED(image) (image) (image) Hey, ED. You know, one of the drawbacks to calling yourself a โ€œScripting Guyโ€ is that people assume youโ€™re really more of a Scripting Fanatic. Every now and then we get emails that say, โ€œHey, Scripting...