Scripting Blog

A place to learn about PowerShell and share stories of automation

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

Hey, Scripting Guy! How can I locate all the instances of a particular file (like budget.xls) on a computer?-- MN 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 his sons are named George Edward ...

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

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 Hey, BW. As we noted a ...

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

Hey, Scripting Guy! How can I get a list of the unique words used in a Microsoft Word document?-- RK 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 the Scripting Coach knew that ...

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

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 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 this: what are we going to do if...

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

Hey, Scripting Guy! How can I copy all the comments from an Excel worksheet to a Word document?-- ED 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 Guy! I read your column on X. ...

Feedback usabilla icon