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…
Year: 2008
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…
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…
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…
Hey, Scripting Guy! How Can I Sort the Contents of a Text File in Numerical Order?
Hey, 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. However, in return, you have to promise to forget everything we tell you….
Hey, Scripting Guy! How Can I Change the Priority of Each Instance of an Application?
Hey, 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? — AM Hey, AM. You know, just yesterday we noted that Hey,…
Hey, Scripting Guy! How Can I Synchronize a Text File of Folder Names With the Subfolders in a Folder?
Hey, 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,…
Hey, Scripting Guy! How Can I Import Multiple Worksheets into an Access Database?
Hey, 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. How can I import multiple worksheets into an Access…
Hey, Scripting Guy! How Can I Search For Values in an Excel Worksheet?
Hey, 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…
Hey, Scripting Guy! How Can I Use Windows PowerShell to Replace Characters in a Text File?
Hey, Scripting Guy! Using Windows PowerShell, how can I replace all the asterisks in a text file with some other character? — RC Hey, RC. You know, a lot of people ask the Scripting Guy who writes this column, “How do you do it? How do you manage to write a new column each and…