Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Hey, Scripting Guy! How Can I Sort the Contents of a Text File in Numerical Order?

(image) 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 (image) (image) (image) 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. (Which is usually not ...

Hey, Scripting Guy! How Can I Change the Priority of Each Instance of an Application?

(image) 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(image) (image) (image) Hey, AM. You know, just yesterday we noted that Hey, Scripting ...

Hey, Scripting Guy! How Can I Synchronize a Text File of Folder Names With the Subfolders in a Folder?

(image) 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, C:\Scripts\Test Folder – actually exists.) ...

Hey, Scripting Guy! How Can I Import Multiple Worksheets into an Access Database?

(image) 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?

(image) Hey, Scripting Guy! How can I use Excel’s Find method to search for values within a worksheet?-- SK(image) (image) (image) 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 ...