Scripting Blog [archived]

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

January 2008 - Page 2 of 5 - Scripting Blog [archived]

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

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

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

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

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

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