Scripting Blog

A place to learn about PowerShell and share stories of automation

January 2008 - Scripting Blog

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

January 31, 2008 Jan 31, 2008 01/31/08
ScriptingGuy1
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?

January 30, 2008 Jan 30, 2008 01/30/08
ScriptingGuy1
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?

January 29, 2008 Jan 29, 2008 01/29/08
ScriptingGuy1
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?

January 28, 2008 Jan 28, 2008 01/28/08
ScriptingGuy1
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?

January 25, 2008 Jan 25, 2008 01/25/08
ScriptingGuy1
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 ...