Showing archive results for 2007

Sep 19, 2007
Post comments count0
Post likes count0

How Can I Move Files Off a User’s Desktop and Into Specified Folders?

ScriptingGuy1

Hey, Scripting Guy! For various reasons, we don’t want our users storing “loose” files on their desktop. How can I write a script that will take all the files on the user’s desktop and, based on the file extension, move those files to the appropriate desktop folder? For example, if I have a file with a .doc file extension I’d like to move it to a...

Scripting Guy!VBScriptdesktop management
Sep 18, 2007
Post comments count0
Post likes count0

How Can I Parse a Comma-Separated Values File?

ScriptingGuy1

Hey, Scripting Guy! I have a text file which consists of individual fields separated by commas. I need to look at the second field in each line and, if it includes the word Everyone, I then need to take the sixth field in the line and write that value to a second text file. How can I do that?-- RP Hey, RP. You know, a lot of you are probably sit...

Scripting Guy!scripting techniquesVBScript
Sep 15, 2007
Post comments count0
Post likes count0

How Can I Extract Text Embedded Between Target Phrases in a Text File?

ScriptingGuy1

Hey, Scripting Guy! How can I read a text file until I encounter a specified phrase, then write that information to a new text file? I then need to repeat this process, reading the text file to the next instance of the phrase and then writing that information to another new file. And so on.-- EW Hey, EW. You know, this has been a difficult year ...

Scripting Guy!scripting techniquesVBScript
Sep 14, 2007
Post comments count0
Post likes count0

How Can I Determine Which Version of Windows Vista is Installed on a Computer?

ScriptingGuy1

Hey, Scripting Guy! How can I determine which version of Windows Vista is installed on a computer?-- GC Hey, GC. You know, Microsoft is one of the largest and most successful companies the world has ever known. And yet, despite all our successes, we’re really no different than any anyone else: for example, from time-to-time we get a little jealo...

Scripting Guy!VBScriptoperating system
Sep 13, 2007
Post comments count0
Post likes count0

How Can I Update and Then Break All the Links in an Excel Spreadsheet?

ScriptingGuy1

Hey, Scripting Guy! How can I open an Excel spreadsheet, update all the links to other Excel spreadsheets, and then break those links?-- YH Hey, YH. Before we begin, we’d like to make an announcement: the Scripting Guy who writes this column gives up. To tell you the truth, that’s not something we ever expected to say; after all, the Scripting G...

Scripting Guy!VBScriptOffice