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

Jan 24, 2008
0
0

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

ScriptingGuy1
ScriptingGuy1

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. (Which is usually not a problem for most people.) What do y...

Scripting Guy!scripting techniquesVBScript
Jan 23, 2008
0
0

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

ScriptingGuy1
ScriptingGuy1

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, Scripting Guy! is theplaceto come if you’re looki...

Scripting Guy!VBScriptoperating system
Jan 22, 2008
0
0

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

ScriptingGuy1
ScriptingGuy1

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.) This part of the s...

Scripting Guy!scripting techniquesVBScript
Jan 21, 2008
0
0

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

ScriptingGuy1
ScriptingGuy1

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 database?-- EA ...

Scripting Guy!VBScriptOffice
Jan 18, 2008
0
0

Hey, Scripting Guy! How Can I Search For Values in an Excel Worksheet?

ScriptingGuy1
ScriptingGuy1

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 through March 3rd, right here in the ...

Scripting Guy!VBScriptOffice