Scripting Blog

A place to learn about PowerShell and share stories of automation

Hey, Scripting Guy! How Can I Use Windows PowerShell to Retrieve the Non-Unique Items in a List?

Hey, Scripting Guy! I understand that I can use Windows PowerShell and the Get-Unique cmdlet to determine which items are unique in a collection. However, I want to do the opposite: I want to determine which items are not unique in a collection. How can I do that?-- YE Hey, YE. You know, yesterday afternoon, just as he was getting ready to ...

Hey, Scripting Guy! How Can I Display a Message or Change the Cursor When Carrying Out a Lengthy Operation in an HTA?

Hey, Scripting Guy! I have an HTA in which I do a search and create a table with the results. The search takes quite some time, 30 seconds or so. The results are displayed within a span and show up only once the search is complete. I would like a message ("Searching...") to appear in the span as soon as the search starts, then be replaced by ...

Hey, Scripting Guy! How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?

Hey, Scripting Guy! I need a script that can read all the values in a spreadsheet and then change the background colors of the cells in that spreadsheet based on a range of values. For example, if the value is less than 20 the cell gets colored one color; if the cell is between 20 and 40 it gets colored another color; and so on. How do I do ...

Hey, Scripting Guy! How Can I Create a Disk Quota That Gives the User Unlimited Disk Space?

Hey, Scripting Guy! Your article "Managing Disk Quotas in Windows Server 2003 and Windows XP" is quite good but it leaves out one important detail: how can you specify an unlimited disk quota for a user?-- CA Hey, CA. You know, it’s funny. When we received this question, we had no idea what the answer was. In fact, we were just about to ...

Hey, Scripting Guy! How Can I Schedule an All-Day Event in Microsoft Office Outlook?

Hey, Scripting Guy! How can I schedule an all-day event in Microsoft Office Outlook?-- RL Hey, RL. Have you ever heard the expression “every dog has its day”? Well, if you haven’t, the idea is that sooner or later everyone will have their moment in the sun, that sooner or later everyone will have a day when things actually ...

Feedback usabilla icon