A place to learn about PowerShell and share stories of automation
January 31, 2008Jan 31, 200801/31/08Hey, 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.
January 30, 2008Jan 30, 200801/30/08Hey, 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.
January 29, 2008Jan 29, 200801/29/08Hey, 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;
January 28, 2008Jan 28, 200801/28/08Hey, 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,
January 25, 2008Jan 25, 200801/25/08Hey, 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,
January 24, 2008Jan 24, 200801/24/08Hey, Scripting Guy! I have a text file in which each line begins with a number. How can I sort the contents of that file by those numbers?
— KT
Hey, KT. Tell you what: we’ll go ahead and answer your question.
January 23, 2008Jan 23, 200801/23/08Hey, Scripting Guy! Is there any way to permanently change the priority of a process? If there isn’t, how can I write a script that will monitor for new instances of this process and then change the priority each time the application runs?
January 22, 2008Jan 22, 200801/22/08Hey, Scripting Guy! I have a script that reads through a text file and then checks a folder to see if all the subfolder names listed in that text file actually exist. (For example, if the parent folder is C:\Scripts the script might check to see if a folder named Test Folder – that is,
January 21, 2008Jan 21, 200801/21/08Hey, Scripting Guy! I’m trying to import a spreadsheet into an Access database. The problem is that the spreadsheet has multiple worksheets. I can import the first worksheet without any problem, but I can’t figure out how to import all the other worksheets in the file.
January 18, 2008Jan 18, 200801/18/08Hey, Scripting Guy! How can I use Excel’s Find method to search for values within a worksheet?
— SK
Hey, SK. Before we begin today, we have a question for you, and for everyone else out there in Scripting Land. Back when the Scripting Guys first started planning the 2008 Winter Scripting Games (February 15th through March 3rd,
